Hello,
I have already activated this option in the registry. It is necessary in order to avoid a connection drop when the
clientis idle for some time.
But my problem is different here. I would like a connection to be dropped on the server when the client has
disconnected...
Philippe
-----Message d'origine-----
De : Richard Huxton [mailto:dev@archonet.com]
Envoyé : jeudi, 22. janvier 2004 11:33
À : Philippe Lang; pgsql-odbc@postgresql.org
Objet : Re: [ODBC] Idle connections - Too many clients connected already
On Thursday 22 January 2004 06:57, Philippe Lang wrote:
> Hello,
>
> After using Postgresql for a while, through ODBC / MS Access, I'm not
> able to connect to the server anymore. The server reports "Too many
> clients connected already".
[snip]
> Is there a way to avoid that? I cannot certifiy that clients will
> always close their connexions in a clean way. So, is the server able
> to check if clients are still alive, and close their connection if
> it's not the case?
You can set a timeout for the ODBC on each client. I can't remember if this is in the odbc driver settings panel or
where.Worst case, it's a registry setting. That should do what you want.
--
Richard Huxton
Archonet Ltd