Re: MS-Access connection with oracle via odbc loses connection after 12 minutes

Hello,

Search for a key in the registry called "ConnectionTimeout":

Here it is:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\ODBC]
"TraceODBCAPI"=dword:00000000
"DisableAsync"=dword:00000001
"TraceSQLMode"=dword:00000000
"QueryTimeout"=dword:0000003c
"LoginTimeout"=dword:00000014
"ConnectionTimeout"=dword:00000258 <---- HERE
"TryJetAuth"=dword:00000001
"FatBlastRows"=dword:ffffffff
"FatBlastTimeout"=dword:00000003
"AsyncRetryInterval"=dword:000001f4
"AttachCaseSensitive"=dword:00000000
"FastRequery"=dword:00000000
"ODBCISAMAttach"=dword:00000000
"PreparedInsert"=dword:00000000
"PreparedUpdate"=dword:00000000
"SnapshotOnly"=dword:00000000
"AttachableObjects"="'TABLE','VIEW','SYSTEM TABLE','ALIAS','SYNONYM'"

By default, this value is set to 258. Set it to 0, and you won't be disconnected anymore. The reason why the other application does not disconnect is a bit strange, but we could imagine some kind of keep-alive built into the application.

Philippe

-----Message d'origine-----
De : pgsql-odbc-owner(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)org] De la part de Liesbeth Van den Abeele
Envoyé : mardi, 9. mars 2004 15:09
À : pgsql-odbc(at)postgresql(dot)org
Objet : [ODBC] MS-Access connection with oracle via odbc loses connection after 12 minutes

MS Access client starts up. Connection with oracle databse via odbc is activated and runs perfectly.

After 12 minutes, without an action in the client the the oracle connection is closed.

Another access application on the same oracle server with the same odbc driver runs well.

Why does the connection closes after 12 minutes?

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings