>I do not get a specific error, because it is an ODBC connection. I get a -1 as a return value. Ex:
>lnHandle = SQLEXEC(lnCon,"Exec sp_setapprole 'Role','Password')
>
>lnHandle is getting a return value of -1 which means I did not get a connection.
Try AERROR()
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown