Hi Doug,

I am honored.
I have your software and am reading your paper on error handling.
Your answer explains my problem.
Unfortunately Aerror will be empty or have data from a different error.
I will stick to my little messagebox alert.

Thanks
Jim



>Hi Jim.
>
>>I put an ON ERROR DO ODBCErrorHandler in my connection method code.
>
>Note that SQLCONNECT() and SQLSTRINGCONNECT() do not cause an error if they fail -- they simply return a negative number. So, unless you specifically call ODBCErrorHandler, VFP won't call it for you if the connection fails.
>
>Doug