🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #1322

Strange behaviour of ADOConnection

#1322
From: Francesco
Date: Tue, 17 Aug 2004 20:50
32 lines
1532 bytes
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
Technical Details
Message-ID: <41226f7a@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!logbridge.uoregon.edu!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,323a17fad324853a,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Francesco" <.>
Subject: Strange behaviour of ADOConnection
Newsgroups: borland.public.cppbuilder.database.ado
User-Agent: XanaNews/1.16.3.1
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 80.182.4.36
Message-ID: <41226f7a@newsgroups.borland.com>
Date: 17 Aug 2004 13:50:02 -0700
X-Trace: newsgroups.borland.com 1092775802 80.182.4.36 (17 Aug 2004 13:50:02 -0700)
Lines: 32
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!logbridge.uoregon.edu!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail