Unable to Drop the database
Hi,
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
sridhar.bandalamudi@ecanarys.com
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
sridhar.bandalamudi@ecanarys.com
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
wiseapp
18 years ago
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.
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.
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
