> -----Original Message-----
> From: Hiroshi Inoue [mailto:Inoue@tpf.co.jp]
> Sent: 05 December 2002 02:53
> To: Raymond O'Donnell
> Cc: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] Connections sitting idle...
>
>
>
> 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.
I'm pretty sure this is the underlying ADO. It's for this reason that
pgAdmin can't drop databases - no matter how you tell ADO to close the
connection , it 'helpfully' keeps it open preventing you from ever
dropping that database.
Regards, Dave.