Hi James,

As I read your code the error handler is not invoked because there is never an error. You tested for a valid connection handle with the following line:

IF lnHandle < 1

Even had you not done that an error would still not be invoked until later in code if you tried to use an SPT (SQL Pass Through) statetment, based on a bad conneciton handle, where you retrieved data and then tried to use the data from the results of the SPT statement.

You have to test for a valid connection handle as you did. FoxPro really doesn't care if the connection was made or not.

John


>Hello Group,
> When I pass a bad username and password to the following code I get the messagebox that "Connection Failed" but the error handler was not involked. When I send correct username and password it connects. Why isn't an error raised. I am reading Doug Hennig as we speak but it is sinking in slowly.
>
>Thanks
>Jim
>
>lParam lcServer, lcUserID, lcPassword, lcDatabase
>Local lnHandle,lcConnect
>
>ON ERROR DO ODBCErrorHandler
>
>lcConnect= "DRIVER={SQL Server};Server=" + lcServer + ";UID=" + lcUserID + ";PWD=" + lcPassword + ";Network=DBMSSOCN;" + "DATABASE=" + lcDatabase + ";"
>
>lnHandle = SQLSTRINGCONNECT(lcConnect)
>
>
>IF lnHandle < 1 then && No Connection was made
>
> MESSAGEBOX("Connection Failed")
> RETURN 0
>
>ELSE && connection made return the connection Handle
>
> RETURN lnHandle
>
>ENDIF
>
>ON ERROR
>
>PROCEDURE ODBCErrorHandler
>LOCAL lcErrorString
>
>=AERROR(eray)
>lcErrorString = "Error Number " + alltrim(str(eray(1)))
>MessageBox(lcString)
>
>ENDPROC && ODBCErrorHandler
>