WiX v3 is not stable right now. WiX v2 works much better. When WiX v2 is complete (soon, assuming shipping Vista and Office lets up soon) then I'll port all those fixes up to WiX v3.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nicholas Piasecki Sent: Wednesday, January 31, 2007 3:18 PM To: wix-users@lists.sourceforge.net Subject: [WiX-users] SqlString works but SqlScript bombs in WiX v3.0? Dear All, I've playing with WiX for a week now and it's a great toolset, but I've hit a wall with a particularly strange error. I'm using WiX 3.0.2526 (last week's build). Here's a snippet from my .wxs file: <sql:SqlDatabase Id="MsSqlDatabase" Database="anova" Server="(local)\SQLEXPRESS" CreateOnInstall="yes" DropOnUninstall="yes" ContinueOnError="no"> <sql:SqlString Id="Blah" ExecuteOnInstall="yes" SQL='CREATE TABLE "Pants" ( "Id" int not null )' /> </sql:SqlDatabase> The above works great -- the database is created with a "Pants" table sitting inside it. Unfortunately, I've got about a bajillion such queries to run, so I thought I'd use SqlScript instead: <sql:SqlDatabase Id="MsSqlDatabase" Database="anova" Server="(local)\SQLEXPRESS" CreateOnInstall="yes" DropOnUninstall="yes" ContinueOnError="no"> <sql:SqlScript Id="MsSqlDdlInstall" BinaryKey="CreateMsSqlDdlScript" ExecuteOnInstall="yes" /> </sql:SqlDatabase> For testing purposes, I've put the same exact "CREATE TABLE" line that I used in SqlString in the file identified by the binary key in SqlScript. But every time I run the installer, it exits prematurely: MSI (s) (D8:78) [17:22:55:953]: Doing action: ConfigureSql Action 17:22:55: ConfigureSql. Configuring SQL Server Action start 17:22:55: ConfigureSql. MSI (s) (D8:58) [17:22:55:968]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI14A7.tmp, Entrypoint: ConfigureSql MSI (s) (D8:58) [17:22:55:984]: Leaked MSIHANDLE (14105) of type 790531 for thread 2028 MSI (s) (D8:58) [17:22:55:984]: Leaked MSIHANDLE (14104) of type 790531 for thread 2028 MSI (s) (D8:58) [17:22:55:984]: Leaked MSIHANDLE (14103) of type 790540 for thread 2028 MSI (s) (D8:58) [17:22:55:984]: Leaked MSIHANDLE (14102) of type 790540 for thread 2028 MSI (s) (D8:58) [17:22:55:984]: Leaked MSIHANDLE (14092) of type 790541 for thread 2028 MSI (s) (D8:58) [17:22:55:984]: Note: 1: 2769 2: ConfigureSql 3: 5 DEBUG: Error 2769: Custom Action ConfigureSql did not close 5 MSIHANDLEs. The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2769. The arguments are: ConfigureSql, 5, Action ended 17:22:56: ConfigureSql. Return value 3. I saw postings that referred to the encoding of this file; I've tried ANSI, UTF-8, and UTF-16 (Big and Little Endian), but still no joy. Any thoughts or ideas? I appreciate it! V/R, Nicholas Piasecki ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier. Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier. Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users