Raymond O'Donnell wrote:
> Hello all,
> I've been having a lot of trouble with connections sitting around
> idle for a long time after a query has executed. I'm building a web
> app which uses ADO on a windows computer to talk to the ODBC driver
> (version 7.02.0004, installed with pgAdmin II), which then talks to
> PostgreSQL on a Linux machine.
> I've been looking at the psqlodbc-xxxxx.log and basically, what is
> happening is that the query is executed as normal, then nothing
> happens for about 80 seconds (during which I can see the idle backend
> process on the linux server), and then suddenly the command
> "PGAPI_Disconnect" appears in the log and the backend finally
> I've tried this (i) calling the ADO objects from an ASP script (see
>  below) and (ii) calling the ADO objects from a COM DLL created in
> Delphi (pretty much the same as in the ASP script) to be called from
> an ASP script. In both cases, the backend hung around for about 80s,
> even though the connection has been explicitly closed and the
> connection object removed from memory. I've appended a typical set of
> log entries at  below.
> Interestingly, creating another Delphi app that talks to Postgres via
> either the Zeos components (which don't use either ADO or ODBC)
> causes the backed to die immediately once the connection is closed.
> This seems to imply to me that either ADO or the ODBC driver itself
> is for some reason keeping the connection open rather than closing it
Yes IIS uses the connection pooling mechanism by default.
Pooled connections would be re-used if possible for other
sessions without re-establishing new connections.
Anyway I can't see other sessions' info at all in your
example. How do other sessions behave ?
In response to
pgsql-odbc by date
|Next:||From: Hiroshi Inoue||Date: 2002-12-05 05:15:40|
|Subject: Re: [ODBC] Drop column and Access|
|Previous:||From: Raymond O'Donnell||Date: 2002-12-05 00:31:18|
|Subject: Connections sitting idle...|