From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch>, <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Idle connections - Too many clients connected already |
Date: | 2004-01-22 10:32:31 |
Message-ID: | 200401221032.31478.dev@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Frank Joerdens | 2004-01-22 11:36:43 | OpenOffice: SetPos with data_at_exec not yet supported |
Previous Message | Dave Page | 2004-01-22 08:48:00 | Re: Tables/Columns in upper-case? |