Timeout on ODBC connection ????

[suzreid]

Is there a timeout property on an ODBC connection?

I have an Access application that connects to an Oracle database via ODBC and when I'm updating the Oracle tables it seems to randomly give me ODBC connection failure errors.

Is there anything I can do to stop the application dropping the connection?

 

[snyderj]

In query design mode, open the query properties and increase the ODBC timeout.

Sometimes you can improve the response time by changing the way the query is written. If you get good response with just two linked tables, then link to a third and it times out, it might help to nest one query in another.

 

[billbarl]

Also, use regedit.exe and look at:
\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\ODBC

There are parameters for LoginTimeout, QueryTimeout, and ConnectionTimeout that you can change to increase the defaults.