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:[email protected]]
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:[email protected]]
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 <[email protected]> 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:[email protected]]
> 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:[email protected]]
> Sent: 28 May 2010 19:58
> To: [email protected]
> 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
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/wix-users
>
> ----------------------------------------------------------------------
> --------
>
> _______________________________________________
> WiX-users mailing list
> [email protected]
> 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
[email protected]
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
[email protected]
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/wix-users
