Re: [WiX-users] WiX v3 Sql Extension not executing SqlScript

[EdB]

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

[EdB]

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