Access 2002 and ODBC timeout

[John]

I am encountering what appears to be a ODBC timeout when
linking to an Oracle Database. I have found in other
newsgroups that others have had the same thing happen when
connecting to mySQL or other backend ODBC connected
databases; their recommendation was to set the ODBC
registry key value
(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0
\Engines\ODBC) to 0 (default is 600 seconds). This is
running on Windows 2000 SP4 and Office XP SP2.

Is there a preferred/better fix for this?

Thanks for any advice-
John

 

[Joe Fallon]

If it is just a connection then it should not take anywhere close to 5
minutes.
More like 10-20 seconds.

Are you executing a long running query?

I link to Oracle and SQL Server all the time w/o problems.