Pally, That's close, but it doesn't work because it tries to run on install and I need it to run on uninstall. I knew it had to be some kind of InstallExecuteSequence, I just wasn't sure of the to make it work with uninstall. By the way, is there a list of these actions and install steps that I can reference?
Thanks! Nate On Thu, Jun 3, 2010 at 5:52 AM, Pally Sandher <pally.sand...@iesve.com> wrote: > Couldn't you just reschedule the ExecuteSqlStrings action by adding it to the > InstallExecuteSequence with the appropriate Before="" or After="" attribute? > > That's how I worked around an issue with the SchedXMLConfig action before it > was modified to run after the DuplicateFiles action as it would error in a > pre-final build of WiX v3.0 if you tried to use XMLConfig on a CopyFile'd > file. Try something like: > > <InstallExecuteSequence> > <Custom Action="ExecuteSqlStrings" After="InstallInitialize" /> > </InstallExecuteSequence> > > You may want to pop your MSI open in InstEd!/Orca first to check the > InstallExecuteSequence & copy any Condition set on ExecuteSqlStrings into > your code. > > 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: dB. [mailto:dbl...@dblock.org] > Sent: 03 June 2010 12:13 > To: General discussion for Windows Installer XML toolset. > Subject: Re: [WiX-users] Detach Databases on Uninstall > > There's a set of immediate custom actions in http://msiext.codeplex.com that > you can schedule at will. The one you want is ODBCExecute. > > There's also a whole stack of Wix extensions for ODBC generically and SQL > server specifically if you decide that what's included in Wix doesn't do it > for you. > > cheers > dB. > > dB. @ dblock.org > Moscow|Geneva|Seattle|New York > > > -----Original Message----- > From: Nathan Zaugg [mailto:nza...@gmail.com] > Sent: Wednesday, June 02, 2010 7:07 PM > To: General discussion for Windows Installer XML toolset. > Subject: Re: [WiX-users] Detach Databases on Uninstall > > I think I now have some insight. The reason I can't connect is because WIX > detected that SQL Server was using a file that was included in the > installation and stopped SQL Server during the uninstall. > > Any idea how I coax it to running those scripts toward the beginning of the > uninstall? > > > > Action 17:02:12: ExecuteSqlStrings. Executing SQL Strings MSI (s) (F8:F4) > [17:02:12:349]: Executing op: > CustomActionSchedule(Action=ExecuteSqlStrings,ActionType=25601,Source=BinaryData,Target=**********,CustomActionData=**********) > MSI (s) (F8:F4) [17:02:12:358]: Creating MSIHANDLE (44) of type 790536 for > thread 5108 MSI (s) (F8:6C) [17:02:12:359]: Invoking remote custom action. > DLL: > C:\Windows\Installer\MSIC91F.tmp, Entrypoint: ExecuteSqlStrings MSI (s) > (F8!80) [17:02:29:356]: Creating MSIHANDLE (45) of type 790531 for thread 1152 > ExecuteSqlStrings: Error 0x80004005: continuing after failure to connect to > database: master MSI (s) (F8!80) [17:02:29:356]: Closing MSIHANDLE (45) of > type 790531 for thread 1152 MSI (s) (F8!80) [17:02:29:357]: Creating > MSIHANDLE (46) of type 790531 for thread 1152 > ExecuteSqlStrings: Error 0x80004005: continuing after failure to connect to > database: master MSI (s) (F8!80) [17:02:29:357]: Closing MSIHANDLE (46) of > type 790531 for thread 1152 MSI (s) (F8!80) [17:02:29:357]: Creating > MSIHANDLE (47) of type 790531 for thread 1152 > ExecuteSqlStrings: Error 0x80004005: continuing after failure to connect to > database: master MSI (s) (F8!80) [17:02:29:358]: Closing MSIHANDLE (47) of > type 790531 for thread 1152 MSI (s) (F8!80) [17:02:29:358]: Creating > MSIHANDLE (48) of type 790531 for thread 1152 > ExecuteSqlStrings: Error 0x80004005: continuing after failure to connect to > database: master MSI (s) (F8!80) [17:02:29:358]: Closing MSIHANDLE (48) of > type 790531 for thread 1152 MSI (s) (F8!80) [17:02:29:358]: Creating > MSIHANDLE (49) of type 790531 for thread 1152 > ExecuteSqlStrings: Error 0x80004005: continuing after failure to connect to > database: master MSI (s) (F8!80) [17:02:29:359]: Closing MSIHANDLE (49) of > type 790531 for thread 1152 MSI (s) (F8!80) [17:02:29:359]: Creating > MSIHANDLE (50) of type 790531 for thread 1152 > ExecuteSqlStrings: Error 0x80004005: continuing after failure to connect to > database: master MSI (s) (F8!80) [17:02:29:359]: Closing MSIHANDLE (50) of > type 790531 for thread 1152 MSI (s) (F8:6C) [17:02:29:363]: Closing MSIHANDLE > (44) of type 790536 for thread 5108 > > > On Tue, Jun 1, 2010 at 4:55 PM, Michael Osmond <mosm...@baytech.com.au> wrote: >> 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 >> > > ------------------------------------------------------------------------------ > ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day > Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list > and enter to win: > http://p.sf.net/sfu/thinkgeek-promo > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > ------------------------------------------------------------------------------ > ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day > Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list > and enter to win: > http://p.sf.net/sfu/thinkgeek-promo > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > > > ------------------------------------------------------------------------------ > ThinkGeek and WIRED's GeekDad team up for the Ultimate > GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the > lucky parental unit. See the prize list and enter to win: > http://p.sf.net/sfu/thinkgeek-promo > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > ------------------------------------------------------------------------------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users