🚀 go-pugleaf

ADO maintains connection pool, so when you disconnect it does not actually
release connection. Try to add "OLE DB Services=-2" to your connection
string.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Francesco" <.> ???????/???????? ? ???????? ?????????:
news:41226f7a@newsgroups.borland.com...
> Hello,
>
> I've an ADOConnection, I've noticed that once connected even if I
> disconnect, the DB is still in use.
> I'll explain better:
>
>
> I've an ADOConnection that connect to a database as specified in
> ConnectionString
>
> ADOConnection1->Connected = true;
>
> I do smth with ADOQuery connected to that ADOConnection for example a
> select from table 1...
>
>
> after that I close the Query and the connection too
>
> ADOQuery1->Close();
> ADOConnection1->Connected = false;
>
> Now if I try to connect directly to database using another ADOQuery and
> putting directly the connection string in the query and I do smth that
> I need to have the exclusive access to DB (for example checking a
> table).
>
> I've an error saying that the Database is still in use.
>
>
> Am I forgetting anything or is a bug? Any Idea?
>
> thanks, Francesco