Re: [WiX-users] WiX v3 Sql Extension not executing SqlScript
Amy, Our DB installation process originally specified the SQL instance by name regardless of it being the default instance or not. We discovered that if we named the default instance (MSSQLSERVER) DB creation would fail with "unknown error" after 10-15 minutes of churning along. Changing our process to only use an instance name if it is non-default allows our db build to work correctly. We don't use the filespec elements (default names are fine for us) so there may be something not working with those that is impacting you. You could try removing more elements and attributes and see if allowing default values to be used helps this. Amy Rosewater wrote: > > I tried removing the additional attributes, and still the same result. > Nothing gets executed against the database when a SqlScript node is > present (even if it does not appear under the SqlDatabase node) except a > preliminary check to see if a database with my name exists. > > > > Amy Rosewater > > Sr. Development Programmer/Analyst > > -- View this message in context: http://www.nabble.com/WiX-v3-Sql-Extension-not-executing-SqlScript-tf4643760.html#a13353670 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
Re: [WiX-users] WiX v3 Sql Extension not executing SqlScript
Just a quick bit of extra info on WiX version numbers: The first two digits of the Build part (major.minor.build.revision) are the 'project month number'. I think for WiX 3.0 this started at 10 and has incremented every month since. The second two digits are the day within the month. WiX 3.0 is still in a state of flux and hasn't been through stabilisation. Almost anything is allowed to change. Serious bugs may be fixed, but those fixes may introduce serious bugs of their own. The code may be reorganized and in the process, broken. Take your choice - latest feature set, or stabilized code? For the latter, choose v2. The latest builds can always be found at http://wix.sourceforge.net/releases. There's a build approximately every week, or more frequently if there's a serious regression, but it's as and when Rob and the other maintainers release one. If a feature doesn't work for you, try the build before or after. Particularly stable builds are placed on the main SourceForge project page at http://sourceforge.net/project/showfiles.php?group_id=105970&package_id=1688 88 after they've bedded down a little. You can see from these sites that the most recent build, 3419, was released last week on the 19th of October, and is about five months newer than the build you're currently working with, which is the latest on the SourceForge project page. -- Mike Dimmick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of EdB Sent: 18 October 2007 01:20 To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] WiX v3 Sql Extension not executing SqlScript I am able to use these elements successfully with 3.0.3328.0. This is the first v3 build I've used so don't know if there was an intentional change between these releases. Amy Rosewater wrote: > > 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. > > > > -- View this message in context: http://www.nabble.com/WiX-v3-Sql-Extension-not-executing-SqlScript-tf4643760 .html#a13265661 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 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
Re: [WiX-users] WiX v3 Sql Extension not executing SqlScript
Apparently WiX v3 is working differently than WiX v2 that I use. Good luck! From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Amy Rosewater Sent: Thursday, October 18, 2007 12:45 PM To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] WiX v3 Sql Extension not executing SqlScript I tried removing the additional attributes, and still the same result. Nothing gets executed against the database when a SqlScript node is present (even if it does not appear under the SqlDatabase node) except a preliminary check to see if a database with my name exists. 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] From: Chad Petersen [mailto:[EMAIL PROTECTED] Sent: Thursday, October 18, 2007 9:18 AM To: Amy Rosewater; wix-users@lists.sourceforge.net Subject: RE: [WiX-users] WiX v3 Sql Extension not executing SqlScript 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? ... ... ... ... http://schemas.microsoft.com/wix/UtilExtension"; /> ... 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
Re: [WiX-users] WiX v3 Sql Extension not executing SqlScript
I tried removing the additional attributes, and still the same result. Nothing gets executed against the database when a SqlScript node is present (even if it does not appear under the SqlDatabase node) except a preliminary check to see if a database with my name exists. 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] From: Chad Petersen [mailto:[EMAIL PROTECTED] Sent: Thursday, October 18, 2007 9:18 AM To: Amy Rosewater; wix-users@lists.sourceforge.net Subject: RE: [WiX-users] WiX v3 Sql Extension not executing SqlScript 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? ... ... ... ... http://schemas.microsoft.com/wix/UtilExtension"; /> ... 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
Re: [WiX-users] WiX v3 Sql Extension not executing SqlScript
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? ... ... ... ... http://schemas.microsoft.com/wix/UtilExtension"; /> ... 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
Re: [WiX-users] WiX v3 Sql Extension not executing SqlScript
I am able to use these elements successfully with 3.0.3328.0. This is the first v3 build I've used so don't know if there was an intentional change between these releases. Amy Rosewater wrote: > > 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. > > > > -- View this message in context: http://www.nabble.com/WiX-v3-Sql-Extension-not-executing-SqlScript-tf4643760.html#a13265661 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
[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? ... ... ... ... http://schemas.microsoft.com/wix/UtilExtension"; /> ... 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