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