ODBC Error Handling 1

[speja01]

Hi Everyone,

I'm having an issue trapping a ODBC timeout coming from a SQL Pass through query. The query times out but the subroutine isn't capturing the error message. It just continues with the next line of code. The subroutine does have the On Error check in it. The results of the pass through query are displayed in a list box. The backend database is Oracle 8i. Below is the command which is timing out

Me![lstPart].RowSource = "SELECT * FROM " & CONST_FRM_SEARCH_QUERY

"CONST_FRM_SEARCH_QUERY is the pass through query." When the query times out the next line of code is executed and the list box is empty. How come the timeout is not being detected? Any information is appreciated.

Thanks

 

[vbajock]

These can be pretty tough, what ever the error is, sometimes Oracle just doesn't pass it's error information to the Access error object, and other times, it is in some property other than the Error$ or err.description. This Kb shows how to get the entire collection, if you play with it you might find the error being returned somewhere:

http://support.microsoft.com/kb/167957/EN-US/

Can you set a timeout property on the connection object? If so, set to zero.