Hi Chris, Sorry, I am still on WiX 2, but that should not matter. In WiX 2 both <SqlScript> and <SqlString> have a Sequence attribute. Make sure that <SqlScript> is scheduled after InstallFiles standard action (usual Sequence number 4000).
Regards, Alex -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Eldredge Sent: Thursday, January 31, 2008 1:15 PM To: wix-users@lists.sourceforge.net Subject: [WiX-users] InstallExecuteSequence for Sql Actions I'm trying to create an MSI that installs a .NET assembly and registers it for use in SQL Server 2005. The problem is that the SQL I'm executing inside a SqlString is telling SQL Server to load the assembly, but when I install the MSI it seems that the assembly hasn't been copied to its final destination when the SQL action executes. My question: is it possible to change the order that the actions execute in such that the assembly will be where it is supposed to be by the time the SQL commands start executing? Thanks, Chris My WiX 3 markup (abridged) <Component Id="MyAssembly.dll" <File Name="MyAssembly.dll" Id="MyAssembly.dll" Source="..." /> <Component Id="Database"> <SqlDatabase xmlns="http://schemas.microsoft.com/wix/SqlExtension"; Id="MyDb" ConfirmOverwrite="no" CreateOnInstall="yes" DropOnUninstall="yes" Server="[ComputerName]" Database="MyDb"> <SqlString Id="SQLString01" ExecuteOnInstall="yes" SQL="create assembly FoolEncryption from '[#FoolAssembly]'" /> </SqlDatabase> <CreateFolder /> </Component> </Component> ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
