Re: Connections sitting idle...

> -----Original Message-----
> From: Raymond O'Donnell [mailto:rod@iol.ie]
> Sent: 05 December 2002 09:53
> To: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] Connections sitting idle...
>
>
> ...and on 5 Dec 2002 at 8:06, Dave Page wrote:
>
> > 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.
>
> Does you mean that ADO keeps the connection open regardless of
> whether or not connection pooling is turned on? Is there any way to
> control this behaviour? I don't see anything in the properties of the
> ADO connection object to affect this, but maybe I just missed it at
> 2.00 am..... :)

Yes, that's the conclusion I came to. I've yet to find a way around the
problem :-(

Regards, Dave.