Hi,
I am creating a database using the following wix code.
<sql:SqlDatabase Id="PWDB" Database="pwdb"
Server="localhost" CreateOnInstall="yes"
CreateOnReinstall="yes"
DropOnInstall="no" DropOnReinstall="no"
DropOnUninstall="no" ContinueOnError="no">
On the first installation it creates the db successfully. During reinstall, if
one the db scripts fails to run (any script running on this db using
sqlstring), then during rollback setup tries to delete the database.
MSI (s) (9C:B8) [22:26:01:440]: Executing op:
CustomActionRollback(Action=RollbackCreateDatabase,ActionType=1281,Source=BinaryData,Target=DropDatabase,CustomActionData=PWDB€localhost€€PWDB€65€1€€)
MSI (s) (9C:2C) [22:26:01:440]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI304.tmp, Entrypoint: DropDatabase
DropDatabase: Error 0x80040e14: failed to drop to database: 'PWDB', error:
Cannot drop database "PWDB" because it is currently in use.
MSI (s) (9C!18) [22:26:22:431]: Product: Sql Setup -- Error 26202. Error
-2147217900: failed to drop SQL database: PWDB, error detail: Cannot drop
database "PWDB" because it is currently in use..
Error 26202. Error -2147217900: failed to drop SQL database: PWDB, error
detail: Cannot drop database "PWDB" because it is currently in use..
Can someone pls tell me why this happens and how to avoid this? In this
particular case db didn't get deleted, but I am really worried it will get
deleted during one of the upgrade and we will loose user data.
Thanks,
Paramesh
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
