Odbc timeout settings

[mindbender]

All of a sudden I have started getting the ORA-01013 timeout error when I run queries that are longer than 60 seconds. I have never run into this before. I know I can update the timeout value in the property sheet of the queries individually.

Is there a way to do this globally for all queries and all databases to set the value to 0 so they never time out?

Also has anyone else seen this or know why all of a sudden it has started happening?

[JamesDeckert]

http://www.geeksengine.com/article/h...ccess-sql.html

shows how to change registry timeout value

[ranman256]

it can also happen if it works normally, but heavy traffic on the db at that moment will cause the error too.

[ItsMe]

I could take a wild guess that a linked table is referenced in a query and the table is causing the timeout. You might look into the Timeout value for linked tables. IIRC, 0 is no timeout. Also, it might be the server is causing the timeout. As mentioned, the client may not be the cause and maybe its possible the server has a setting to cause the timeout, dunno.