I would verify your speculation by running sql server profiler during install
________________________________
From: [EMAIL PROTECTED] on behalf of chetan1983
Sent: Fri 8/10/2007 19:16
To: wix-users@lists.sourceforge.net
Subject: [WiX-users] Executing Multiple Sql scripts
Hi All,
I need to run multiple sql scripts from wix which will crate multiple
databases.
I wrote following code to accomplish the above task....
<Component Id="SQLComponent" Guid="C50999A0-02FD-42d5-9F65-7375318DD328">
<sql:SqlDatabase Id="DB" Database="DB1" Server="localhost"
CreateOnInstall="yes" >
<sql:SqlScript Id="DBSqlScript1" ExecuteOnInstall="yes"
BinaryKey="DatabaseSqlScript1" />
</sql:SqlDatabase>
<sql:SqlDatabase Id="DB2" Database="DB2" Server="localhost"
CreateOnInstall="yes" >
<sql:SqlScript Id="DBSqlScript2" ExecuteOnInstall="yes"
BinaryKey="DatabaseSqlScript2" />
</sql:SqlDatabase>
</Component>
where binary key are the multiple sql script files.
now when I install the msi, it creates the databases, but did not run the
first script completely, but the second script was run properly.
Now the Problem is that it executes the last script file properly. What I
speculate the problem could be is that while the first script is still
running the second script starts running, which interrupts with the first
script and rollbacks the work done by it. (this is what I think, it may or
may not be true.)
Can anybody help me with this problem????? its very urgent.
Thanks and Regards,
Chetan Garg
--
View this message in context:
http://www.nabble.com/Executing-Multiple-Sql-scripts-tf4250019.html#a12095490
Sent from the wix-users mailing list archive at Nabble.com.
-------------------------------------------------------------------------
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
This e-mail and any attachment is for authorised use by the intended
recipient(s) only. It may contain proprietary material, confidential
information and/or be subject to legal privilege. It should not be copied,
disclosed to, retained or used by, any other party. If you are not an intended
recipient then please promptly delete this e-mail and any attachment and all
copies and inform the sender. Thank you.
-------------------------------------------------------------------------
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
