Skip site navigation (1) Skip section navigation (2)

"Maximum number of conections exceeded" when connnecting via Postgres ODBC

From: "Andy Kelk" <andy(at)venda(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: "Maximum number of conections exceeded" when connnecting via Postgres ODBC
Date: 2002-08-20 13:42:35
Message-ID: 2BA3903C0E9C284F9AA18B2E123CF5ED2DA29D@VENDAC01.uk.venda (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi,

I have a Windows 2000 Server that is running some queries from an ASP
page.
It uses the ODBC driver to connect to a Postgres database running on a
Linux machine. 
Most of the time the ASP page works fine but after a while of the
machine being
live I get the an error connecting complaining about errors in
SQLAllocHandle.

When I run the commlog I get the following lines:

ENVIRON ERROR: func=PGAPI_AllocConnect, desc='', errnum=1,
errmsg='Maximum number of connections exceeded.'

CONN ERROR: func=PGAPI_GetConnectOption, desc='fOption=1209',
errnum=205, errmsg='Unknown connect option (Get)'
            ------------------------------------------------------------
            henv=50597728, conn=168672848, status=1, num_stmts=16
            sock=50600880, stmts=50600800, lobj_type=-999
            ---------------- Socket Info -------------------------------
            socket=3028, reverse=0, errornumber=0, errormsg='(NULL)'
            buffer_in=168638632, buffer_out=168642736
            buffer_filled_in=63, buffer_filled_out=0, buffer_read_in=63


Rebooting the machine solves this problem.
At the same time as getting the error above I repeatedly try connecting
to the database from the Linux machines and there is no problem.

Does anyone have any experience of a similar problem or have any advice?

Thanks

Andy

pgsql-odbc by date

Next:From: Kevin PlouffeDate: 2002-08-20 19:00:52
Subject: Problem with Access 2002 and Postgres ODBC
Previous:From: Stelios SfakianakisDate: 2002-08-20 13:07:51
Subject: Re: Text as long varchar?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group