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@xxxxxxxxxxxxxx [mailto:pgsql-odbc-owner@xxxxxxxxxxxxxx] 
De la part de Liesbeth Van den Abeele
Envoyé : mardi, 9. mars 2004 15:09
À : pgsql-odbc@xxxxxxxxxxxxxx
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



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster