You might try it to start with in a bit simpler format. Just have the
ExecuteOnInstall="yes"
And remove the
ContinueOnError="no" RollbackOnUninstall="yes"
If it works then add back in one of those two at a time. You might find
the ContinueOnError="no" is causing a problem. They are said to be
OR'ing the values to build up the Attributes, but I feels like they AND
because for me anything set to "no" makes it not work.
________________________________
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Amy
Rosewater
Sent: Wednesday, October 17, 2007 3:24 PM
To: wix-users@lists.sourceforge.net
Subject: [WiX-users] WiX v3 Sql Extension not executing SqlScript
Hi,
Is this still an issue with the version 3.0.2925.0?
I have a WiX v3 installation which uses the SqlDatabase to create a
database. This works great. However, as soon as I add a child
SqlScript and a corresponding Binary my installation just hangs until I
kill the process and never executes the sql in the referenced file. I
put a trace on SQL Server and I don't even see the statements that were
previously getting executed successfully by the SqlDatabase node before
adding that SqlScript.
I tried executing the first statement in my (unfortunately) long sql
script through the SqlString element, and it was successful, but I was
hoping to avoid the extra work involved in translating all those
statements in my scripts into strings.
I saw a couple posts regarding similar, but not the same problems. Is
there something obvious I might be doing wrong, or do I just need to
steer clear of the SqlScript for now?
...
<Component Id="CreateDatabases"
Guid="66B197B5-42D0-462F-A97E-760D984C38FC">
<sql:SqlDatabase Id="IVantageDatabase"
Server="[SQLSERVER]" Database="[DATABASENAME]"
User="InstallationSqlUser" CreateOnInstall="yes" DropOnUninstall="yes">
<sql:SqlFileSpec Id="IVantageDatabaseFile"
Filename="[DataDirectory][DATABASEFILENAME].mdf"
Name="[DATABASEFILENAME]" />
<sql:SqlLogFileSpec Id="IVantageDatabaseLogFile"
Filename="[DataDirectory][DATABASEFILENAME]_Log.ldf"
Name="[DATABASEFILENAME]_Log" />
<sql:SqlScript Id="ExecuteIVantageDLLSql"
BinaryKey="ExecuteIVantageDDLSqlBin" ExecuteOnInstall="yes"
ContinueOnError="no" RollbackOnUninstall="yes" Sequence="001"
User="InstallationSqlUser" />
</sql:SqlDatabase>
</Component>
...
<Feature Id="iVantage" Title="iVantage 5.0" Level="1">
...
<ComponentRef Id="CreateDatabases" />
...
</Feature>
<util:User Id="InstallationSqlUser" Name="[SQLUSER]"
Password="[SQLUSERPASSWORD]"
xmlns:util="http://schemas.microsoft.com/wix/UtilExtension"; />
<Binary Id="ExecuteIVantageDDLSqlBin"
SourceFile="..\Business\Data\iVantage40DDL.sql" />
...
Thanks,
Amy Rosewater
Sr. Development Programmer/Analyst
SPECTRUM Human Resource Systems Corporation
707 Seventeenth Street, Suite 3800
Denver, CO 80202-3438
(303) 592-3403 Phone
(800) 334-5660 Toll Free
(303) 592-3233 Fax
[EMAIL PROTECTED]
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
