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

From: "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch>
To: <pgsql-odbc(at)postgresql(dot)org>
Cc: "Liesbeth Van den Abeele" <liesbeth(dot)vandenabeele(at)atosorigin(dot)com>
Subject: Re: MS-Access connection with oracle via odbc loses connection after 12 minutes
Date: 2004-03-10 06:58:24
Message-ID: 6C0CF58A187DA5479245E0830AF84F42080237@poweredge.attiksystem.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Markus Wollny 2004-03-10 08:27:54 Re: Oracle Dev2000 using PostgreSQL as Database
Previous Message scott.marlowe 2004-03-09 23:47:10 Re: THANK YOU