Hi Another option to trace this is to use SQL Profiler - it should show the calls being made and any errors occurring.
By setting ContinueOnError="yes" any errors will be swallowed (they may be in the log). If you are doing this only to make the uninstall robust against the database not existing, perhaps you should wrap the detach process in a test of the database existing instead. Michael -----Original Message----- From: Pally Sandher [mailto:pally.sand...@iesve.com] Sent: Wednesday, 2 June 2010 4:12 AM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Detach Databases on Uninstall Try using "msiexec /i <msiname> /l*vx <logname>" to get verbose logs. I'm not sure on what info the WiX Standard Custom Actions like SqlExtension put into the logs but those options should get everything & might help point out where it's failing. For some reason I've got a feeling there is some Property or variable you may need to set to get the Standard Custom Actions to put more stuff into the logs, not 100% sure on that though & I can't find any reference to it anywhere so I might be mixing it up with something else. Hopefully if it does exist someone else will remember what I'm rambling about & clarify. Palbinder Sandher Software Deployment & IT Administrator T: +44 (0) 141 945 8500 F: +44 (0) 141 945 8501 http://www.iesve.com **Design, Simulate + Innovate with the <Virtual Environment>** Integrated Environmental Solutions Limited. Registered in Scotland No. SC151456 Registered Office - Helix Building, West Of Scotland Science Park, Glasgow G20 0SP Email Disclaimer -----Original Message----- From: Nathan Zaugg [mailto:nza...@gmail.com] Sent: 28 May 2010 19:58 To: wix-users@lists.sourceforge.net Subject: [WiX-users] Detach Databases on Uninstall I am trying to detach databases on uninstall. I know the commands I have work but for some reason this action fails. We're using integrated authentication and I wonder if that might be part of it. I have also tried running osql/sqlcmd as an install action. It didn't work either and it didn't give me anything interesting in the log. Any suggestions? If I run these commands from a command line they work fine. Thanks! Nate <sql:SqlDatabase Id="Master" Server="." Instance="SQLEXPRESS" Database="master" /> <sql:SqlString Id="OfflineQCEW" ContinueOnError="yes" ExecuteOnUninstall="yes" SqlDb="Master" SQL="ALTER DATABASE QCEW.Deploy SET OFFLINE WITH ROLLBACK IMMEDIATE" /> <sql:SqlString Id="DetachQCEW" ContinueOnError="yes" ExecuteOnUninstall="yes" SqlDb="Master" SQL="EXEC master.dbo.sp_detach_db @dbname = N'[iQFolder]\QCEW.Deploy.MDF'"/> <!--Detach QCEWCommon--> <sql:SqlString Id="OfflineQCEWCommon" ContinueOnError="yes" ExecuteOnUninstall="yes" SqlDb="Master" SQL="ALTER DATABASE QCEWCommon SET OFFLINE WITH ROLLBACK IMMEDIATE" /> <sql:SqlString Id="DetachQCEWCommon" ContinueOnError="yes" ExecuteOnUninstall="yes" SqlDb="Master" SQL="EXEC master.dbo.sp_detach_db @dbname = N'[iQFolder]\QCEWCommon.MDF'"/> <!--Detach QCEWSecurity--> <sql:SqlString Id="OfflineQCEWSecurity" ContinueOnError="yes" ExecuteOnUninstall="yes" SqlDb="Master" SQL="ALTER DATABASE QCEWSecurity SET OFFLINE WITH ROLLBACK IMMEDIATE" /> <sql:SqlString Id="DetachQCEWSecurity" ContinueOnError="yes" ExecuteOnUninstall="yes" SqlDb="Master" SQL="EXEC master.dbo.sp_detach_db @dbname = N'[iQFolder]\QCEWSECURITY.MDF'"/> Action 19:16:00: ExecuteSqlStrings. Executing SQL Strings ExecuteSqlStrings: Error 0x80004005: continuing after failure to connect to database: master ExecuteSqlStrings: Error 0x80004005: continuing after failure to connect to database: master ExecuteSqlStrings: Error 0x80004005: continuing after failure to connect to database: master ExecuteSqlStrings: Error 0x80004005: continuing after failure to connect to database: master ExecuteSqlStrings: Error 0x80004005: continuing after failure to connect to database: master ExecuteSqlStrings: Error 0x80004005: continuing after failure to connect to database: master ------------------------------------------------------------------------------ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
