[WiX-users] Unable to execute sql scripts

Hi, I'm new to WIX and I'm having some problems executing SQL scripts. I have looked at a number of posts and none of them have worked. I have also looked for any SQL Server logs that would help and I couldn't find any. The error messages that I'm receiving in the install log are...

Re: [WiX-users] Unable to execute sql scripts

Thanks for the reply. The database is on the local machine. I'm not sure how to turn on profiling but I will take a look. One thing I forgot to mention is that the scripts will run in SQL Server Management Console under the same user that is in the user element. I was wondering if the user and

Re: [WiX-users] Unable to execute sql scripts

I changed the util:user to use sa as the user and it worked. So the problem is definitely a permissions issue. The problem is that I have to be able to use Windows authentication. When the database is created the flag is set to create the current user as an administrator

[WiX-users] When trying to execute a SQL script there are garbage characters

I am trying to execute an SQL script that creates a database and when I do I receive the following errors... Error 26204. Error -2147217900: failed to execute SQL string, error detail: Incorrect syntax near '»'., SQL key: CreateDatabase SQL string: USE [master] The CreateDatabase.sql code

Re: [WiX-users] Unable to execute sql scripts

The current user is created as a sysadmin when SQL Server is installed. This is done as part of a bundle just prior to running the install that creates the database. -- View this message in context:

Re: [WiX-users] When trying to execute a SQL script there are garbage characters

Thanks Kieth, that was it. I changed the SQL scripts to use codepage 1252 and everything worked! -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/When-trying-to-execute-a-SQL-script-there-are-garbage-characters-tp7596247p7596258.html Sent from the

Re: [WiX-users] Unable to execute sql scripts

I have resolved the problem by moving the sqldatabase element outside of a component. By doing that it the installer is not trying to create the database (I have a script for that) and I no longer need a until:user and the installer seems to be using the current user to run the SQL scripts. Here

[WiX-users] How to create a feature tree with an msi and a bundle

I have a system that consists of two components, a client and a server. The client will always get installed and the server is optional. If the server is selected to be installed SQL Server also needs to be installed as a prereq. I have created a separate msi for both the client and the server. I

[WiX-users] Setting a Burn variable in c# code

I have created an installer with one msi (client) and a bundle (server). I have also created a custom Burn UI that has two buttons, one to install only the client and one to install both the client and the server. In the custom ui I created two variables installClientOnly and installClientServer.

Re: [WiX-users] Passing Variables from C# custom BA to WIX

I purchased the book WIX 3.6: A Developer's Guide to Windows Installer XML. In chapter 16 it explains, step by step, how to pass variables to the WIX XML from a custom BA. In the example they are using bindings for setting the variable but in my custom BA I set them in C# code. -- View this

[WiX-users] Cannot execute the ICommand InstallCommand in C# code behind

I have a WIX installer custom BA. In it I have 2 buttons. In the click event handlers I set some variables so I can only determine which features of the product I need to install. When I execute the InstallCommand it doesn't start the install, instead the log says canceling... My code is...

Re: [WiX-users] Cannot execute the ICommand InstallCommand in C# code behind

Thanks for the response Jacob. I commented out the close and it didn't still install. -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Cannot-execute-the-ICommand-InstallCommand-in-C-code-behind-tp7596330p7596336.html Sent from the wix-users

[WiX-users] Unable to get install button to enable

Hi, I have an installer that will install either a client only, or both the client and the server. The way I determine which one to install is by having a custom ui with two check boxes. A variable is set and checked in the chain to decide if one or both (client and server) is to be installed.

Re: [WiX-users] Unable to get install button to enable

I was looking for the wrong Id in the detect routine. -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-get-install-button-to-enable-tp7597419p7597433.html Sent from the wix-users mailing list archive at Nabble.com.

[WiX-users] Error database does not exist when executing ExecuteSQLStrings

I have an installer that needs to execute a number of sql scripts. For some reason they are not getting executed and so I receive the above message. here is my Product.was file.. ?xml version=1.0 encoding=UTF-8? Wix xmlns=http://schemas.microsoft.com/wix/2006/wi;

Re: [WiX-users] Error database does not exist when executing ExecuteSQLStrings

I changed my product.was to the following but when I test it it doesn't create the database. I don't receive any errors when I run it, it just doesn't create anything. My product.was... Component Id='SqlComponent' Guid='A60B1852-7C4B-402B-A619-EECA2893C5AC' KeyPath='yes'

Re: [WiX-users] Error database does not exist when executing ExecuteSQLStrings

Hi, Is there anyone that has created a database using SQL scripts? I have a requirement to complete this installer and I can't get the database created. Thanks, Gary -- View this message in context:

Re: [WiX-users] Error database does not exist when executing ExecuteSQLStrings

Thanks for the reply! After looking at the verbose log I didn't see where the database was being created so I removed the condition and changed the SQLDatabase to use 'sa' with a password. I'm now receiving errors when the database is being created... Action 12:18:29: CreateDatabase. Creating

[WiX-users] How to create a feature set that installs an msi and a bundle exe

I have an application that consists of two components, a client and a server. The client will always get installed and the server is optional. If the server is selected to be installed SQL Server also needs to be installed as a prereq. I have created a separate msi for the client. For the server

Re: [WiX-users] How to create a feature set that installs an msi and a bundle exe

Thanks for the reply. I would prefer two bundles, which I sort of have now. Currently I have an msi for the client and a bundle for the server because of the SQL Server requirement. How can I combine them into a single msi/exe with each one being a feature on a feature tree? Thanks, Gary --

Re: [WiX-users] How to create a feature set that installs an msi and a bundle exe

If I create a bundle for the client can I use the standard bootstrapper? -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/How-to-create-a-feature-set-that-installs-an-msi-and-a-bundle-exe-tp7598468p7598472.html Sent from the wix-users mailing list

[WiX-users] Always show the option dialog

I have a bundle that shows the license agreement and it has a button to go to an option dialog. From the option dialog you can set the option and then close the dialog going back to the license agreement. from there you can install the application if you've agreed to the license. I want to go

Re: [WiX-users] Always show the option dialog

Can someone point me to some documentation on how to change the UI sequence for a bundle? Thanks, Gary -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Always-show-the-option-dialog-tp7598481p7598495.html Sent from the wix-users mailing list

[WiX-users] Install condition is not being set in options dialog

I have modified the RtfLicense theme to include a checkbox. The name of the checkbox is the same name as the variable name that I use in the install condition. When I execute the bundle and check the checkbox the variable is always false. bundle.was... Variable Name=INSTALLSERVER / Chain

Re: [WiX-users] Install condition is not being set in options dialog

If I set the variable INSTALLSERVER to 1 Variable Name=INSTALLSERVER Value=1/ Then the checkbox is checked and the server install starts, but if I check the checkbox in the options dialog it does not set the variable to 1. garymonk wrote I have modified the RtfLicense theme to include

Re: [WiX-users] Install condition is not being set in options dialog [P]

I do not see anything in the log that shows that the checkbox is being initialized. I copied the variable statement and the checkbox statement from your code and changed the names and I still do not see anything in my log. My log looks like this... [022C:2E6C][2014-12-10T16:51:33]i000:

Re: [WiX-users] Install condition is not being set in options dialog [P]

The problem is that I moved the install button from the EULA Welcome dialog to the Options dialog. Because I do not click on the Ok button the variable doesn't get set. Is the best way to handle this is to create a separate dialog for the server option and remove the option dialog altogether?

Re: [WiX-users] Install condition is not being set in options dialog [P]

Here is the bundle... Bundle Name=Guru Teach Installation Version=6.1.0.0 Manufacturer=Guru Dental UpgradeCode=ef8d3106-2b45-4ff2-b95b-3d24b4ef5f2f BootstrapperApplicationRef Id=WixStandardBootstrapperApplication.RtfLicense bal:WixStandardBootstrapperApplication LicenseFile=C:\VS

[WiX-users] Unable to select radio buttons in Hyperlink Theme

I have modified the Hyperlink theme install page to include two radio buttons. Page Name=Install Text X=160 Y=100 Width=-11 Height=17 FontId=3Select software to install/Text Button Name=ClientInstall X=160 Y=130 Width=-11 Height=17 TabStop=yes FontId=3 HexStyle=0x04Guru Teach

Re: [WiX-users] Unable to select radio buttons in Hyperlink Theme

I added the following statements to the bundle... Variable Name=InstallClient Type=numeric Value=0 / Variable Name=InstallServer Type=numeric Value=0 / and modified the button statements as follows... Button Name=ClientInstall X=160 Y=130 Width=-11 Height=17 TabStop=yes FontId=3

Re: [WiX-users] Unable to select radio buttons in Hyperlink Theme [P]

I changed the variables to... Variable Name=InstallClient Type=numeric bal:Overridable=yes Value=1 / Variable Name=InstallServer Type=numeric bal:Overridable=yes Value=0 / and they are still disabled. Is this a bug? Thanks, Gary -- View this message in context:

Re: [WiX-users] Unable to select radio buttons in Hyperlink Theme

I have the following code and they are still disabled. Bundle Name=Guru Teach Installation Version=6.0.4.0 Manufacturer=Guru Dental UpgradeCode=ef8d3106-2b45-4ff2-b95b-3d24b4ef5f2f BootstrapperApplicationRef Id=WixStandardBootstrapperApplication.HyperlinkLicense

Re: [WiX-users] Unable to select radio buttons in Hyperlink Theme

I don't have anything like that coded. I'm new to WIX and I wasn't aware that I needed to do any coding. That's not a problem if someone could explain to me, or point me to some documentation, on how to do it. Thanks, Gary -- View this message in context:

Re: [WiX-users] Unable to select radio buttons in Hyperlink Theme [P]

Thank you Steve, and everyone else that contributed. I had the names backwards. I must have looked at that a thousand times. Thanks again!! -- View this message in context:

[WiX-users] QuickTime is installing when it is already installed.

I have a bundle that installs a number of prerequisites. One of those prereqs is QuickTime. Here is the code... ExePackage Id=Package_QuickTime Cache=no Compressed=$(var.Compressed) Description=Apple QuickTime 7 DownloadUrl=$(var.DownloadRepo)/{2}

Re: [WiX-users] QuickTime is installing when it is already installed.

Thank you for the reply. Will the code you provided work with both 32 and 64 bit systems? Thanks, Gary -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/QuickTime-is-installing-when-it-is-already-installed-tp7600756p7600763.html Sent from the

Re: [WiX-users] QuickTime is installing when it is already installed.

I cannot get this to work correctly. Here is the log... [08B4:040C][2015-07-06T10:50:14]i000: Registry key not found. Key = 'HKEY_LOCAL_MACHINE\SOFTWARE\Clients\Media\QuickTime' [08B4:040C][2015-07-06T10:50:14]i000: Setting numeric variable 'QuickTimeFound64' to value 0

Re: [WiX-users] QuickTime is installing when it is already installed.

Amazing that I could look at that so many times and not see that. Thanks you for the help!! -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/QuickTime-is-installing-when-it-is-already-installed-tp7600756p7600831.html Sent from the wix-users mailing