Hi All,
I have a database component which creates a new database during install,
and is set to drop that same database on uninstall. This behavior used
to work perfectly, but recently has stopped working and I am not sure
why. I did not change versions of Wix, nor did I change the database
component node below.
<sql:SqlDatabase Id="IVantageDatabase" Server="[SQLSERVER]"
Database="[DATABASENAME]" User="InstallationSqlUser"
CreateOnInstall="yes" DropOnUninstall="yes">
...(several install only sql strings here)
<sql:SqlString Id="DisconnectUsersFromDatabase"
User="InstallationSqlUser" ExecuteOnUninstall="yes"
ExecuteOnInstall="no" SQL="ALTER DATABASE [DATABASENAME] SET SINGLE_USER
with ROLLBACK IMMEDIATE" Sequence="901"/>
<sql:SqlString Id="DropLoginIfExistsIninstall"
User="InstallationSqlUser" ExecuteOnUninstall="yes"
ExecuteOnInstall="no" SQL="if exists (select * from sys.syslogins where
name='[APPLICATIONUSER]') DROP LOGIN [APPLICATIONUSER]" Sequence="902"
/>
</sql:SqlDatabase>
>From my log when it worked:
Action start 11:46:33: MigrateFeatureStates.
Action ended 11:46:33: MigrateFeatureStates. Return value 0.
Action start 11:46:33: SetCAINSTALLEDTrue.
Action ended 11:46:33: SetCAINSTALLEDTrue. Return value 1.
Action start 11:46:33: InstallValidate.
Action ended 11:46:36: InstallValidate. Return value 1.
Action start 11:46:36: InstallInitialize.
Action ended 11:46:36: InstallInitialize. Return value 1.
Action start 11:46:36: ProcessComponents.
Action ended 11:46:37: ProcessComponents. Return value 1.
Action start 11:46:37: UnpublishFeatures.
Action ended 11:46:37: UnpublishFeatures. Return value 1.
Action start 11:46:37: StopServices.
Action ended 11:46:37: StopServices. Return value 1.
Action start 11:46:37: DeleteServices.
Action ended 11:46:37: DeleteServices. Return value 1.
Action start 11:46:37: UninstallCertificates.
UninstallCertificates: Skipping ConfigureCertificates() - required
table not present.
Action ended 11:46:37: UninstallCertificates. Return value 1.
Action start 11:46:37: UninstallSqlData.
UninstallCertificates: Scheduling SQL string: ALTER DATABASE iVantage50
SET SINGLE_USER with ROLLBACK IMMEDIATE
UninstallCertificates: Scheduling SQL string: if exists (select * from
sys.syslogins where name='iVantageApplication') DROP LOGIN
iVantageApplication
Action start 11:46:43: ExecuteSqlStrings.
Action ended 11:46:43: ExecuteSqlStrings. Return value 1.
Action start 11:46:43: DropDatabase.
Action ended 11:46:43: DropDatabase. Return value 1.
Action ended 11:46:43: UninstallSqlData. Return value 1.
>From my log now that it isn't working:
Action start 9:48:21: MigrateFeatureStates.
Action ended 9:48:21: MigrateFeatureStates. Return value 0.
Action start 9:48:21: SetCAINSTALLEDTrue.
Action ended 9:48:21: SetCAINSTALLEDTrue. Return value 1.
Action start 9:48:21: InstallValidate.
Action ended 9:48:24: InstallValidate. Return value 1.
Action start 9:48:24: InstallInitialize.
Action ended 9:48:24: InstallInitialize. Return value 1.
Action start 9:48:24: ProcessComponents.
Action ended 9:48:25: ProcessComponents. Return value 1.
Action start 9:48:25: UnpublishFeatures.
Action ended 9:48:25: UnpublishFeatures. Return value 1.
Action start 9:48:25: StopServices.
Action ended 9:48:25: StopServices. Return value 1.
Action start 9:48:25: DeleteServices.
Action ended 9:48:25: DeleteServices. Return value 1.
Action start 9:48:25: UninstallCertificates.
UninstallCertificates: Skipping ConfigureCertificates() - required
table not present.
Action ended 9:48:25: UninstallCertificates. Return value 1.
Action start 9:48:25: UninstallSqlData.
Action ended 9:48:32: UninstallSqlData. Return value 1.
Anyone have any ideas why this might have stopped working?
Thanks
Amy Rosewater
SPECTRUM Human Resource Systems Corporation
707 17th Street Suite 3800
Denver CO, 80202
303.592.3403
[EMAIL PROTECTED]
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
