🚀 go-pugleaf

Thanks a lot Viatcheslav, with your advise I solved the problem greatly.

           Francesco




Viatcheslav V. Vassiliev wrote:

> 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