Hi
I'd guess your problem is in the script
BEGIN
ALTER DATABASE [SOLUTIONDATABASENAME]
SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
USE MASTER;
DROP DATABASE [SOLUTIONDATABASENAME];
END"
Does this work in sql management studio - I would guess you need some go
statements - especially after the Use Master.
Better option to do this would be create a SqlDatabase entry for Master that is
located under the Product (so it is not associated with a component).
Then run you alter and drop database scripts as two separate scripts associated
with the Master SqlDatabase entry (these can be under the component). Don't
put the USE statement in at all.
Michael
-----Original Message-----
From: kim [mailto:contactme...@gmail.com]
Sent: Saturday, 12 February 2011 8:04 AM
To: wix-users@lists.sourceforge.net
Subject: [WiX-users] Drop database on Uninstall not working
I want to drop the database installed by my msi on uninstall. It does drops
the Db on roll-back but not on uninstall. Following is the code from my
config file. Since setting DropOnUninstall=yes did not worked, so I added
other sql string to execute Drop database command. I am not receiving any
error on uninstall and verbose log has no errors. It appears to me that the
script is not executed?
can someone suggest whats going wrong here? Thanks!
<Component Id="CreateSolutionDB" DiskId="1"
Guid="{A4957B82-2F6D-44B7-8AD2-44124F69239C}" KeyPath="yes">
<sql:SqlDatabase Id="dbSolution" Server="[SQLSERVERNAME]\[INSTANCENAME]"
Database="[SOLUTIONDATABASENAME]"
CreateOnInstall="yes" ConfirmOverwrite="yes" DropOnReinstall="no"
DropOnUninstall="no">
<sql:SqlScript Id="CreateTablesSqlScriptWindows" ContinueOnError="yes"
ExecuteOnInstall="yes" ExecuteOnReinstall="no" Sequence="1"
BinaryKey="CreateSolutionDBBin" />
<sql:SqlString Id="AddWebcoreLogin" ContinueOnError="no"
ExecuteOnInstall="yes" Sequence="2"
SQL="IF NOT EXISTS(SELECT name FROM sys.server_principals WHERE name =
'[SOLUTIONUSERNAME]')
BEGIN
CREATE LOGIN [SOLUTIONUSERNAME] WITH PASSWORD='[SOLUTIONUSERPASSWORD]';
CREATE USER [SOLUTIONUSERNAME] FOR LOGIN [SOLUTIONUSERNAME];
END;"/>
<sql:SqlString Id="AddRoleToWebcoreUser" ContinueOnError="no"
ExecuteOnInstall="yes" Sequence="3" SQL="EXEC sp_addrolemember
'db_owner','[SOLUTIONUSERNAME]'"/>
<sql:SqlString Id="DropSolutionDB" ContinueOnError="no"
ExecuteOnUninstall="yes" Sequence="2"
SQL="IF EXISTS (SELECT name FROM sys.databases WHERE name =
'[SOLUTIONDATABASENAME]')
BEGIN
ALTER DATABASE [SOLUTIONDATABASENAME]
SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
USE MASTER;
DROP DATABASE [SOLUTIONDATABASENAME];
END"
/>
<sql:SqlString Id="DropWebcoreLogin" ContinueOnError="no"
ExecuteOnUninstall="yes" Sequence="3"
SQL="IF EXISTS(SELECT name FROM sys.server_principals WHERE name =
'[SOLUTIONUSERNAME]')
BEGIN
DROP LOGIN [SOLUTIONUSERNAME];
END"/>
</sql:SqlDatabase>
</Component>
--
View this message in context:
http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Drop-database-on-Uninstall-not-working-tp6017327p6017327.html
Sent from the wix-users mailing list archive at Nabble.com.
------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
