Re: Connections sitting idle... - Mailing list pgsql-odbc

From Dave Page
Subject Re: Connections sitting idle...
Date
Msg-id 03AF4E498C591348A42FC93DEA9661B8128D07@mail.vale-housing.co.uk
Whole thread Raw
In response to Connections sitting idle...  ("Raymond O'Donnell" <rod@iol.ie>)
List pgsql-odbc

> -----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.

pgsql-odbc by date:

Previous
From: "Raymond O'Donnell"
Date:
Subject: Re: Connections sitting idle...
Next
From: "Hiroshi Inoue"
Date:
Subject: Re: [GENERAL] Schemas and ODBC driver.