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