can't drop database

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

Article #4768

Back to borland.public.cppbuilder.database.ado Previous Next

#4768

From: Ernst Maurer
Date: Thu, 18 Oct 2001 07:06

19 lines
1510 bytes

Hi

I have followign task:
Create database on MS SQL Server
execute some task with this database(creating and filling tables)
if user canceled  i must drop this database

I create TADOConnection object and connect to MASTER database , create
MyDatabase on SQL Server.
after this i close connection to MASTER and specify new connectio string to
MyDatabase and open connection.
for delete Mydatabase i disconnect from MyDatabase and open MASTER and
execute "drop database MyDatabase"
BUT HAVE EXCEPTION "Can't drop database "MyDatabase because it is currently
in use"".
What is it? I disconnect from MyDatabase before connect to MASTER for drop
MyDatabase

Ernst

Technical Details

Message-ID: <3bce803d_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!hub.org!hub.org!PeerFeed.KWeb.on.ca!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,a6e6ee123a181365,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-10-18 00:16:41 PST
Reply-To: "Ernst Maurer" <ernst_maurer@mail.ru>
From: "Ernst Maurer" <ernst@texrus.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: can't drop database
Date: Thu, 18 Oct 2001 11:06:57 +0400
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2462.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2462.0000
NNTP-Posting-Host: 195.161.214.37
Message-ID: <3bce803d_2@dnews>
X-Trace: dnews 1003388989 195.161.214.37 (18 Oct 2001 00:09:49 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!hub.org!hub.org!PeerFeed.KWeb.on.ca!dnews