This won't work for me....

The help says this:

SQLSETPROP(nStatementHandle, cSetting [, eExpression])

Parameters
nStatementHandle - Specifies the statement handle to the data source returned by SQLCONNECT( ).

.....so in order to use the SQLSETPROP I must have a connection handle, but if the SQLCONNECT fails & gives me an ODBC error, I wont have a connection handle.


>Hi Victor,
>
>Try this:
>

>=SQLSETPROP(0,"DispLogin",3) && Don't display LOGIN dialog, if any information missed
>=SQLSETPROP(0,"DispWarnings",.F.) && Don't display warning dialog, if any set don't correctly
>x = sqlConnect('myTest')
>if x<=0
>   * Error, use AERROR()
>endif
>

>
>MartinJ
>
>>We have something like this....
>>
>>ON ERROR wait window ('Problem')
>>x = sqlConnect('myTest')
>>
>>The problem is that when we get an ODBC error (connection falied, communications failure, etc) - the ON ERROR doesn't trap the error because it's not a VFP error - it's an ODBC error. Does anyone know how we can trap for this error?
>>
>>Thanks!