Iam Sridhar Babu. i have one issue regarding SQLServer2000.

iam installing .net application with backend MS SQL Server2000.

it is working fine.

when ever i acccess database through application, for each connecation one process will create. and when i close the application the process are closed automatically.

but the process are going to sleeping mode.

my problem is when i am going to uninstall the application

it is showing the error message.

Error 27506.

Cannot frop the database 'database name ' because it is currently in use[3702]

this is done with the help of Install Shield package.

Please help me how to do this problem through programmatically.

Thanks & Regards
B.Sridhar Babu
0 Comments   [ - ] Hide Comments


Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity


Hi Sridhar:

Since you are trying to uninstall your MSI which has dropped and attached the SQL database on the target machine at the time of the installation. At the time of uninstallation, its giving you this error since you have not detached the database and the database is still in use with SQL, write a vbscript/installscript with a SQL command "exec sp_detach_db @dbname=N' {DBName}'. Once the script at the time of uninstallation(While showing the dialogs) detaches the database then you wont get this error. Since I faced a same issue while creating a similar kind of MSI.
Answered 10/31/2005 by: wiseapp
Second Degree Green Belt

Please log in to comment