[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... CreateDatabase: Error 0x80004005: failed to create to database: 'MVDB', error: unknown error Error 26201. Error -2147467259: failed to create SQL database: MVDB, error detail: unknown error. MSI (s) (A4!F4) [13:21:44:978]: Product: Guru 6 -- Error 26201. Error -2147467259: failed to create SQL database: MVDB, error detail: unknown error. CustomAction CreateDatabase returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox) My code looks like this... Binary Id=CreateDatabaseSql SourceFile=C:\VS Publish\SQL Scripts\CreateDatabase.sql / Binary Id=CreateUsersSql SourceFile=C:\VS Publish\SQL Scripts\CreateUsers.sql / Binary Id=CreateBaseLineDbSql SourceFile=C:\VS Publish\SQL Scripts\CreateBaseLineDb.sql / Binary Id=RemoveOldContentSql SourceFile=C:\VS Publish\SQL Scripts\RemoveOldContent.sql / Binary Id=UpgradeSql SourceFile=C:\VS Publish\SQL Scripts\Upgrade.sql / Binary Id=AddCompleteMediaSql SourceFile=C:\VS Publish\SQL Scripts\Upgrade.sql / Binary Id=InstallContentSql SourceFile=C:\VS Publish\SQL Scripts\InstallContent.sql / Binary Id=UpdateCustomPlayListSql SourceFile=C:\VS Publish\SQL Scripts\UpdateCustomPlayList.sql / Binary Id=InstallFeaturedContentSql SourceFile=C:\VS Publish\SQL Scripts\InstallFeaturedContent.sql / DirectoryRef Id=SERVER Component Id='Server.exe' Guid='8027388d-0f90-465b-9668-d1388977caaa' File Id='Server.exe' Source='C:\VS Publish\ProgramFiles\Server\Server.exe' KeyPath='yes'/ ServiceInstall Id=ServiceInstaller Type=ownProcess Name=Service DisplayName=Service Description=Provides media distribution, data coordination, and licensing services to the application Start=auto Account=[SERVICEACCOUNT] Password=[SERVICEPASSWORD] ErrorControl=normal / ServiceControl Id=StartService Start=install Stop=both Remove=uninstall Name=Service Wait=yes / util:User Id=SQLUser Name=[ComputerName]\[%USERNAME] CreateUser=no/ sql:SqlDatabase Id=SqlDatabase Database=MVDB Server=.\MVSQLEXPRESS Instance=MVSQLEXPRESS CreateOnInstall=yes DropOnUninstall=yes ContinueOnError=no User=SQLUser sql:SqlScript Id=CreateDatabase ExecuteOnInstall=yes BinaryKey=CreateDatabaseSql / sql:SqlScript Id=CreateUsers ExecuteOnInstall=yes BinaryKey=CreateUsersSql / sql:SqlScript Id=CreateBaseLineDb ExecuteOnInstall=yes BinaryKey=CreateBaseLineDbSql / sql:SqlScript Id=RemoveOldContent ExecuteOnInstall=yes BinaryKey=RemoveOldContentSql / sql:SqlScript Id=Upgrade ExecuteOnInstall=yes BinaryKey=UpgradeSql / sql:SqlScript Id=AddCompleteMedia ExecuteOnInstall=yes BinaryKey=AddCompleteMediaSql / sql:SqlScript Id=InstallContent ExecuteOnInstall=yes BinaryKey=InstallContentSql / sql:SqlScript Id=UpdateCustomPlayList ExecuteOnInstall=yes BinaryKey=UpdateCustomPlayListSql / sql:SqlScript Id=InstallFeaturedContent ExecuteOnInstall=yes BinaryKey=InstallFeaturedContentSql / /sql:SqlDatabase /Component I have also used... util:User Id=SQLUser Name=[%USERNAME] Domain=[ComputerName] CreateUser=no/ I also tried removing the user altogether from the sql:sqldatabase entry. I have checked that all of the network protocols are enabled for the instance and that there is enough disk space for the database. I would appreciate any help!! Thanks, Gary -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-execute-sql-scripts-tp7596243.html Sent from the wix-users mailing list archive at Nabble.com. -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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 domain combination on the util:user element was the same as the domain\user that I use to sign in to the database through the console. -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-execute-sql-scripts-tp7596243p7596245.html Sent from the wix-users mailing list archive at Nabble.com. -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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 (ADDCURRENTUSERASSQLADMIN=True). Also I can see the current user as an administrator. How do I have WIX create the database using the current user? -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-execute-sql-scripts-tp7596243p7596246.html Sent from the wix-users mailing list archive at Nabble.com. -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[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 is... USE [master] GO DECLARE @data_path nvarchar(256); DECLARE @debug_message nvarchar(2048) SET @debug_message = '' IF NOT EXISTS(SELECT NAME FROM SYSDATABASES WHERE NAME = 'MVDB') AND @data_path = ' ' BEGIN SET @data_path = (SELECT SUBSTRING(filename, 1, CHARINDEX('master.mdf', LOWER(filename)) - 1) FROM master.dbo.sysdatabases WHERE name = 'master'); SET @data_path = @data_path + 'mvdb.mdf'; IF NOT EXISTS(SELECT NAME FROM SYSDATABASES WHERE NAME = 'MVDB') BEGIN CREATE DATABASE [mvdb] IF @@ERROR = 0 BEGIN EXEC dbo.sp_dbcmptlevel @dbname='mvdb', @new_cmptlevel=100 IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) BEGIN EXEC [mvdb].[dbo].[sp_fulltext_database] @action = 'enable' END ALTER DATABASE [mvdb] SET ANSI_NULL_DEFAULT OFF ALTER DATABASE [mvdb] SET ANSI_NULLS OFF ALTER DATABASE [mvdb] SET ANSI_PADDING OFF ALTER DATABASE [mvdb] SET ANSI_WARNINGS OFF ALTER DATABASE [mvdb] SET ARITHABORT OFF ALTER DATABASE [mvdb] SET AUTO_CLOSE ON ALTER DATABASE [mvdb] SET AUTO_CREATE_STATISTICS ON ALTER DATABASE [mvdb] SET AUTO_SHRINK OFF ALTER DATABASE [mvdb] SET AUTO_UPDATE_STATISTICS ON ALTER DATABASE [mvdb] SET CURSOR_CLOSE_ON_COMMIT OFF ALTER DATABASE [mvdb] SET CURSOR_DEFAULT GLOBAL ALTER DATABASE [mvdb] SET CONCAT_NULL_YIELDS_NULL OFF ALTER DATABASE [mvdb] SET NUMERIC_ROUNDABORT OFF ALTER DATABASE [mvdb] SET QUOTED_IDENTIFIER OFF ALTER DATABASE [mvdb] SET RECURSIVE_TRIGGERS OFF ALTER DATABASE [mvdb] SET READ_WRITE ALTER DATABASE [mvdb] SET RECOVERY SIMPLE ALTER DATABASE [mvdb] SET MULTI_USER END END END As you can see there are no garbage characters ( ) at the beginning of the procedure. Do I have to embed the code for each procedure or is there a way to use an external file? Thanks, Gary -- 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-tp7596247.html Sent from the wix-users mailing list archive at Nabble.com. -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-execute-sql-scripts-tp7596243p7596256.html Sent from the wix-users mailing list archive at Nabble.com. -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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 wix-users mailing list archive at Nabble.com. -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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 is my code... sql:SqlDatabase Id=SqlDatabase Database=master Server=localhost Instance=MVSQLEXPRESS / DirectoryRef Id=SERVER Component Id='Server.exe' Guid='8027388d-0f90-465b-9668-d1388977caaa' File Id='Server.exe' Source='C:\VS Publish\ProgramFiles\Server\Server.exe' KeyPath='yes'/ ServiceInstall Id=ServiceInstaller Type=ownProcess Name=Service DisplayName=Media and Licensing Service Description=Provides media distribution Start=auto Account=[SERVICEACCOUNT] Password=[SERVICEPASSWORD] ErrorControl=normal / ServiceControl Id=StartService Start=install Stop=both Remove=uninstall Name=Service Wait=yes / sql:SqlScript Id=CreateDatabase ExecuteOnInstall=yes BinaryKey=CreateDatabaseSql SqlDb=SqlDatabase/ sql:SqlScript Id=CreateUsers ExecuteOnInstall=yes BinaryKey=CreateUsersSql SqlDb=SqlDatabase/ sql:SqlScript Id=CreateBaseLineDb ExecuteOnInstall=yes BinaryKey=CreateBaseLineDbSql SqlDb=SqlDatabase/ sql:SqlScript Id=RemoveOldContent ExecuteOnInstall=yes BinaryKey=RemoveOldContentSql SqlDb=SqlDatabase/ sql:SqlScript Id=Upgrade ExecuteOnInstall=yes BinaryKey=UpgradeSql SqlDb=SqlDatabase/ sql:SqlScript Id=AddCompleteMedia ExecuteOnInstall=yes BinaryKey=AddCompleteMediaSql SqlDb=SqlDatabase/ sql:SqlScript Id=InstallContent ExecuteOnInstall=yes BinaryKey=InstallContentSql SqlDb=SqlDatabase/ sql:SqlScript Id=UpdateCustomPlayList ExecuteOnInstall=yes BinaryKey=UpdateCustomPlayListSql SqlDb=SqlDatabase/ sql:SqlScript Id=InstallFeaturedContent ExecuteOnInstall=yes BinaryKey=InstallFeaturedContentSql SqlDb=SqlDatabase/ /Component Thanks for the help!! Gary -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-execute-sql-scripts-tp7596243p7596259.html Sent from the wix-users mailing list archive at Nabble.com. -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[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 have created a bundle that includes both the SQL Server install along with the server msi. How can I take the three components and create a feature tree so that the client is always installed and the server is optional? Thanks for the help, Gary -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/How-to-create-a-feature-tree-with-an-msi-and-a-bundle-tp7596260.html Sent from the wix-users mailing list archive at Nabble.com. -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[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. What I need to do to complete the installer is to set the two variables based on which button is clicked and pass them on to either the msi or bundle. In both both the msi and bundle I need to check the variable to either bypass or install the software based on the variable. How can I accomplish this? I know I can do this with one variable but I may in the future only want to install the server without the client. Thanks Gary -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Setting-a-Burn-variable-in-c-code-tp7596302.html Sent from the wix-users mailing list archive at Nabble.com. -- ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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 message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Passing-Variables-from-C-custom-BA-to-WIX-tp7596113p7596305.html Sent from the wix-users mailing list archive at Nabble.com. -- ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[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... this.InstallCommand = new DelegateCommand(() = this.model.PlanAction(LaunchAction.Install), () = this.State == InstallState.NotPresent); public InstallView(InstallViewModel viewModel) { InitializeComponent(); this.DataContext = viewModel; this.viewModel = viewModel; model = viewModel.model; this.Closed += (sender, e) = viewModel.CancelCommand.Execute(this); } private void btnInstallClientOnly_Click(object sender, RoutedEventArgs e) { model.SetInstallClient(InstallClient, 1); model.SetInstallServer(InstallServer, 0); if (viewModel.InstallCommand.CanExecute(null)) { model.LogMessage(Executing Install Command); viewModel.InstallCommand.Execute(null); } this.Close(); } This is the log output... [0F60:0E34][2014-08-11T15:02:01]i001: Burn v3.8.1128.0, Windows v6.1 (Build 7601: Service Pack 1), path: J:\Software\Gurusetup.exe, cmdline: '-l installer.txt -burn.unelevated BurnPipe.{A1F2A561-63B7-4764-9287-A49EC349D6B5} {80E463D6-6AA5-43A2-9B39-7AA6705242A8} 4932' [0F60:0E34][2014-08-11T15:02:01]i000: Setting string variable 'WixBundleLog' to value 'J:\Software\installer.txt' [0F60:0E34][2014-08-11T15:02:01]i000: Setting string variable 'WixBundleOriginalSource' to value 'J:\Software\Gurusetup.exe' [0F60:0E34][2014-08-11T15:02:01]i000: Setting string variable 'WixBundleName' to value 'Guru' [0F60:0E34][2014-08-11T15:02:01]i000: Loading managed bootstrapper application. [0F60:0E34][2014-08-11T15:02:01]i000: Creating BA thread to run asynchronously. [0F60:0E34][2014-08-11T15:02:02]i100: Detect begin, 2 packages [0F60:0E34][2014-08-11T15:02:02]i102: Detected related bundle: {0d2675f0-1921-40ff-9a7b-83c2ad0886d2}, type: Upgrade, scope: PerMachine, version: 6.0.4.0, operation: None [0F60:0E34][2014-08-11T15:02:02]i101: Detected package: SQLBundle, state: Absent, cached: None [0F60:0E34][2014-08-11T15:02:02]i101: Detected package: Client, state: Present, cached: None [0F60:0E34][2014-08-11T15:02:02]i199: Detect complete, result: 0x0 [0F60:1040][2014-08-11T15:02:04]i000: Setting numeric variable 'InstallClient' to value 1 [0F60:1040][2014-08-11T15:02:04]i000: Setting numeric variable 'InstallServer' to value 0 [0F60:1040][2014-08-11T15:02:04]i000: Executing Install Command [0F60:1040][2014-08-11T15:02:04]i000: Canceling... [0F60:0E34][2014-08-11T15:02:04]i500: Shutting down, exit code: 0x0 [0F60:0E34][2014-08-11T15:02:04]i410: Variable: InstallClient = 1 [0F60:0E34][2014-08-11T15:02:04]i410: Variable: InstallServer = 0 [0F60:0E34][2014-08-11T15:02:04]i410: Variable: WixBundleAction = 4 [0F60:0E34][2014-08-11T15:02:04]i410: Variable: WixBundleElevated = 1 [0F60:0E34][2014-08-11T15:02:04]i410: Variable: WixBundleLog = J:\Software\installer.txt [0F60:0E34][2014-08-11T15:02:04]i410: Variable: WixBundleManufacturer = Guru Dental [0F60:0E34][2014-08-11T15:02:04]i410: Variable: WixBundleName = Guru [0F60:0E34][2014-08-11T15:02:04]i410: Variable: WixBundleOriginalSource = J:\Software\Gurusetup.exe [0F60:0E34][2014-08-11T15:02:04]i410: Variable: WixBundleProviderKey = {08b31e02-bca5-4816-88fb-56ba0d62a692} [0F60:0E34][2014-08-11T15:02:04]i410: Variable: WixBundleTag = [0F60:0E34][2014-08-11T15:02:04]i410: Variable: WixBundleVersion = 6.0.4.0 [0F60:0E34][2014-08-11T15:02:04]i007: Exit code: 0x0, restarting: No Why doesn't the install start? It is the same command that would normally be bound to a button and that would start the install. I could execute the following line and that works, but I would prefer not to duplicate code. model.PlanAction(Microsoft.Tools.WindowsInstallerXml.Bootstrapper.LaunchAction.Install); Thank you, Gary -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Cannot-execute-the-ICommand-InstallCommand-in-C-code-behind-tp7596330.html Sent from the wix-users mailing list archive at Nabble.com. -- ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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 mailing list archive at Nabble.com. -- ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/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. When the ui is started the the install button is disabled. What I need to have happen is when either of the check boxes is checked I need the install button to enable. When the button is clicked I need to have the install start. The program is not currently listed in Programs and Features. How do I enable the install button programmatically in C#? *Bundle.wxs...* ?xml version=1.0 encoding=UTF-8? Wix xmlns=http://schemas.microsoft.com/wix/2006/wi; xmlns:bal=http://schemas.microsoft.com/wix/BalExtension; Bundle Copyright=Copyright© 2014, Guru Dental, LLC Manufacturer=Guru Dental Name=Guru UpgradeCode={00BA23D8-FB98-43CD-A8A5-CB019552B375} Version=6.0.4 BootstrapperApplicationRef Id=ManagedBootstrapperApplicationHost Payload SourceFile=\\SERVER\RedirectedFolders\gary.monk\My Documents\Visual Studio 2013\Projects\Guru Install Solution\GuruBA\bin\Debug\GuruBA.dll/ Payload SourceFile=\\SERVER\RedirectedFolders\gary.monk\My Documents\Visual Studio 2013\Projects\Guru Install Solution\GuruBA\bin\Debug\BootstrapperCore.config/ Payload SourceFile=\\SERVER\RedirectedFolders\gary.monk\My Documents\Visual Studio 2013\Projects\Guru Install Solution\GuruBA\bin\Debug\Microsoft.Practices.Prism.dll/ /BootstrapperApplicationRef WixVariable Id=WixMbaPrereqPackageId Value=/ WixVariable Id=WixMbaPrereqLicenseUrl Value=/ Chain ExePackage Cache=no InstallCondition=InstallGuruServer Description=SQL Server and Guru Server Bundle Id=GuruSQLBundle SourceFile=\\SERVER\RedirectedFolders\gary.monk\My Documents\Visual Studio 2013\Projects\Guru Install Solution\GuruSQLBundle\bin\Debug\GuruSQLBundle.exe/ MsiPackage Cache=no InstallCondition=InstallGuruClient Description=Guru Client Id=GuruClient SourceFile=\\SERVER\RedirectedFolders\gary.monk\My Documents\Visual Studio 2013\Projects\Guru Install Solution\GuruClientInstall\bin\Debug\GuruClientInstall.msi / /Chain /Bundle /Wix *InstallView.xaml...* Window x:Name=GuruInstaller x:Class=GuruBA.Views.InstallView xmlns=http://schemas.microsoft.com/winfx/2006/xaml/presentation; xmlns:x=http://schemas.microsoft.com/winfx/2006/xaml; xmlns:mc=http://schemas.openxmlformats.org/markup-compatibility/2006; xmlns:d=http://schemas.microsoft.com/expression/blend/2008; mc:Ignorable=d d:DesignHeight=460 d:DesignWidth=700 ResizeMode=NoResize Height=460 Width=700 Icon=\\SERVER\RedirectedFolders\gary.monk\My Documents\Visual Studio 2013\Projects\Guru Install Solution\GuruBA\Images\guru.ico Window.Resources /Window.Resources Grid ShowGridLines=False Grid.RowDefinitions RowDefinition Height=Auto/ RowDefinition/ RowDefinition Height=40/ RowDefinition Height=12/ /Grid.RowDefinitions Grid.ColumnDefinitions ColumnDefinition/ ColumnDefinition/ ColumnDefinition/ /Grid.ColumnDefinitions StackPanel Grid.ColumnSpan=3 Margin=0,0,0,0 Style={StaticResource headerStyle} Border BorderBrush=#FF7FBA00 BorderThickness=2 CornerRadius=8,8,3,3/ WrapPanel Grid.Row=0 Grid.Column=0 Height=100 WrapPanel Margin=0,10,10,10 Image Width=30 Margin=10,0,0,0 Source=\\SERVER\RedirectedFolders\gary.monk\My Documents\Visual Studio 2013\Projects\Guru Install Solution\GuruBA\Images\guru.ico/ /WrapPanel StackPanel Grid.Row=0 Grid.Column=0 Margin=0,5,0,0 TextBlock Text=Guru Installer VerticalAlignment=Top Style={StaticResource headerBoldText} / TextBlock Text=You have chosen to install this software on your system VerticalAlignment=Top FontSize=14 Foreground=White/ /StackPanel /WrapPanel Border BorderBrush=#FF7FBA00 BorderThickness=2 CornerRadius=8,8,3,3/ /StackPanel DockPanel Grid.Row=0 Grid.Column=3 LastChildFill=False Image Width=180 Height=48 DockPanel.Dock=Right VerticalAlignment=Bottom Margin=0,0,0,5 Source=\\SERVER\RedirectedFolders\gary.monk\My Documents\Visual Studio 2013\Projects\Guru Install Solution\GuruBA\Images\guru fax logo.png/ /DockPanel DockPanel Grid.Row=1 Grid.Column=0 Style={StaticResource headerStyle} Grid TextBlock
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. -- Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://p.sf.net/sfu/Zoho ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[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; xmlns:fire=http://schemas.microsoft.com/wix/FirewallExtension; xmlns:sql=http://schemas.microsoft.com/wix/SqlExtension; xmlns:util=http://schemas.microsoft.com/wix/UtilExtension; Product Id=* Name=Guru Teach Server Installation Language=1033 Version=6.0.4.0 Manufacturer=Guru Dental UpgradeCode=76c642f5-9ef3-4575-8ce1-05dd36ea4195 Package InstallerVersion=200 Compressed=yes InstallScope=perMachine Id=* Platform=x86/ MajorUpgrade DowngradeErrorMessage=A newer version of [ProductName] is already installed. / Media Id='1' Cabinet='Data.cab' EmbedCab='yes' DiskPrompt='Please insert DVD #1' / Property Id='DiskPrompt' Value=Guru Teach Installation [1] / Property Id=ARPPRODUCTICON Value=guru.ico / Property Id='CHGFIREWALL' Value='False' Secure='yes'/ UI Id=MyWixUI_Mondo UIRef Id=WixUI_Mondo / UIRef Id=WixUI_ErrorProgressText / DialogRef Id=FirewallDlg / Publish Dialog=WelcomeDlg Control=Next Event=NewDialog Value=FirewallDlg Order=11/Publish Publish Dialog=SetupTypeDlg Control=Back Event=NewDialog Value=FirewallDlg1/Publish /UI sql:SqlDatabase Id=SqlDatabase Database=master Server=localhost Instance=MVSQLEXPRESS / Directory Id=TARGETDIR Name=SourceDir Component Id=RegistryEntries Guid={E677A056-74D9-4AF0-BC88-A4BE8C237E5E} RegistryKey Root=HKLM Key=Software\Reality Engineering, Inc.\Medvisor Dental ForceDeleteOnUninstall=yes RegistryValue Type=string Name=INSTALLDIR Value=[APPLICATIONROOTDIR]/ RegistryValue Type=string Name=ProgName Value=Guru KeyPath=yes/ /RegistryKey /Component Directory Id=ProgramFilesFolder Directory Id=APPLICATIONROOTDIRECTORY Name=Guru Directory Id=AdditionalFolders Directory Id=SERVER Name=Server Directory Id=MANIFESTS Name=Manifests / Directory Id=MODULES Name=Modules / /Directory /Directory /Directory /Directory /Directory Binary Id=CreateDatabaseSql SourceFile=SQL Scripts\CreateDatabase.sql / Binary Id=CreateUsersSql SourceFile=SQL Scripts\CreateUsers.sql / Binary Id=CreateBaseLineDbSql SourceFile=SQL Scripts\CreateBaseLineDb.sql / Binary Id=RemoveOldGuruContentSql SourceFile=SQL Scripts\RemoveOldGuruContent.sql / Binary Id=UpgradeSql SourceFile=SQL Scripts\Upgrade.sql / Binary Id=AddCompleteMediaSql SourceFile=SQL Scripts\Upgrade.sql / Binary Id=InstallGuruContentSql SourceFile=SQL Scripts\InstallGuruContent.sql / Binary Id=UpdateCustomPlayListSql SourceFile=SQL Scripts\UpdateCustomPlayList.sql / Binary Id=InstallFeaturedContentSql SourceFile=SQL Scripts\InstallFeaturedContent.sql / DirectoryRef Id=SERVER Component Id='CreateDtxDataUser.exe' Guid='26f80392-dcbe-47af-a7e0-d187cbec0e15' File Id='CreateDtxDataUser.exe' Source='C:\VS Publish\Guru\ProgramFiles\Guru\Server\CreateDtxDataUser.exe' KeyPath='yes'/ /Component Component Id='Guru.Server.exe' Guid='8027388d-0f90-465b-9668-d1388977caaa' File Id='Guru.Server.exe' Source='C:\VS Publish\Guru\ProgramFiles\Guru\Server\Guru.Server.exe' KeyPath='yes'/ ServiceInstall Id=ServiceInstaller Type=ownProcess Name=GuruService DisplayName=Guru Media and Licensing Service Description=Provides media distribution, data coordination, and licensing services to the Guru application Start=auto Account=[SERVICEACCOUNT] Password=[SERVICEPASSWORD] ErrorControl=normal / ServiceControl Id=StartService Start=install Stop=both Remove=uninstall Name=GuruService Wait=yes / sql:SqlScript Id=CreateDatabase ExecuteOnInstall=yes BinaryKey=CreateDatabaseSql SqlDb=SqlDatabase/ sql:SqlScript Id=CreateUsers ExecuteOnInstall=yes BinaryKey=CreateUsersSql SqlDb=SqlDatabase/ sql:SqlScript Id=CreateBaseLineDb ExecuteOnInstall=yes BinaryKey=CreateBaseLineDbSql SqlDb=SqlDatabase/ sql:SqlScript Id=RemoveOldGuruContent ExecuteOnInstall=yes BinaryKey=RemoveOldGuruContentSql SqlDb=SqlDatabase/ sql:SqlScript Id=Upgrade ExecuteOnInstall=yes BinaryKey=UpgradeSql SqlDb=SqlDatabase/ sql:SqlScript Id=AddCompleteMedia ExecuteOnInstall=yes BinaryKey=AddCompleteMediaSql SqlDb=SqlDatabase/ sql:SqlScript Id=InstallGuruContent ExecuteOnInstall=yes BinaryKey=InstallGuruContentSql SqlDb=SqlDatabase/ sql:SqlScript Id=UpdateCustomPlayList ExecuteOnInstall=yes BinaryKey=UpdateCustomPlayListSql SqlDb=SqlDatabase/ sql:SqlScript Id=InstallFeaturedContent ExecuteOnInstall=yes BinaryKey=InstallFeaturedContentSql SqlDb=SqlDatabase/
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' ConditionUSEINTEGRATEDSECURITY = 1/Condition sql:SqlDatabase Id='SqlDatabase' Database='mvdb' Server='MVSQLEXPRESS' CreateOnInstall='yes' DropOnUninstall='no' ContinueOnError='no'/ sql:SqlScript Id=CreateDatabase ExecuteOnInstall=yes BinaryKey=CreateDatabaseSql SqlDb=SqlDatabase/ sql:SqlScript Id=CreateUsers ExecuteOnInstall=yes BinaryKey=CreateUsersSql SqlDb=SqlDatabase/ sql:SqlScript Id=CreateBaseLineDb ExecuteOnInstall=yes BinaryKey=CreateBaseLineDbSql SqlDb=SqlDatabase/ sql:SqlScript Id=RemoveOldGuruContent ExecuteOnInstall=yes BinaryKey=RemoveOldGuruContentSql SqlDb=SqlDatabase/ sql:SqlScript Id=Upgrade ExecuteOnInstall=yes BinaryKey=UpgradeSql SqlDb=SqlDatabase/ sql:SqlScript Id=AddCompleteMedia ExecuteOnInstall=yes BinaryKey=AddCompleteMediaSql SqlDb=SqlDatabase/ sql:SqlScript Id=InstallGuruContent ExecuteOnInstall=yes BinaryKey=InstallGuruContentSql SqlDb=SqlDatabase/ sql:SqlScript Id=UpdateCustomPlayList ExecuteOnInstall=yes BinaryKey=UpdateCustomPlayListSql SqlDb=SqlDatabase/ sql:SqlScript Id=InstallFeaturedContent ExecuteOnInstall=yes BinaryKey=InstallFeaturedContentSql SqlDb=SqlDatabase/ /Component Feature Id=Server Title=Guru Teach Server Level=1 ComponentRef Id=RegistryEntries/ ComponentRef Id='CreateDtxDataUser.exe' / ComponentRef Id='Guru.Server.exe' / ComponentRef Id='ChangeFirewall' / ComponentRef Id='Guru.Server.exe.config' / ComponentRef Id='Guru.Server.Remoting.dll' / ComponentRef Id='Guru.ServerLibrary.dll' / ComponentRef Id='Ionic.Zip.Reduced.dll' / ComponentRef Id='JsonChannel.dll' / ComponentRef Id='license.dat' / ComponentRef Id='Microsoft.Practices.Prism.dll' / ComponentRef Id='Microsoft.Practices.ServiceLocation.dll' / ComponentRef Id='SQLExpressProvider.dll' / ComponentRef Id='Guru_Featured_manifest.xml' / ComponentRef Id='GURU_Library_manifest.xml' / ComponentRef Id='Guru.Server.Configuration.dll' / ComponentRef Id='SqlComponent'/ /Feature Tanks for the help! Gary -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Error-database-does-not-exist-when-executing-ExecuteSQLStrings-tp7597477p7597489.html Sent from the wix-users mailing list archive at Nabble.com. -- ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Error-database-does-not-exist-when-executing-ExecuteSQLStrings-tp7597477p7597758.html Sent from the wix-users mailing list archive at Nabble.com. -- ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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 Databases MSI (s) (C4:6C) [12:18:29:608]: Executing op: CustomActionSchedule(Action=CreateDatabase,ActionType=25601,Source=BinaryData,Target=**,CustomActionData=**) MSI (s) (C4:C0) [12:18:29:624]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI66CF.tmp, Entrypoint: CreateDatabase CreateDatabase: Error 0x80004005: failed to create to database: 'mvdb', error: unknown error Error 26201. Error -2147467259: failed to create SQL database: mvdb, error detail: unknown error. MSI (s) (C4!E4) [12:18:57:695]: Product: Guru Teach Server Installation -- Error 26201. Error -2147467259: failed to create SQL database: mvdb, error detail: unknown error. CustomAction CreateDatabase returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox) Action ended 12:18:57: InstallFinalize. Return value 3. The product.was now looks like this... util:User Id='SQLUser' Name='sa' Password='' / Component Id='SqlComponent' Guid='A60B1852-7C4B-402B-A619-EECA2893C5AC' KeyPath='yes' sql:SqlDatabase Id='SqlDatabase' Database='mvdb' Server='MVSQLEXPRESS' User='SQLUser' CreateOnInstall='yes' DropOnUninstall='no' ContinueOnError='no'/ sql:SqlScript Id=CreateUsers ExecuteOnInstall=yes BinaryKey=CreateUsersSql SqlDb=SqlDatabase/ sql:SqlScript Id=CreateBaseLineDb ExecuteOnInstall=yes BinaryKey=CreateBaseLineDbSql SqlDb=SqlDatabase/ sql:SqlScript Id=RemoveOldGuruContent ExecuteOnInstall=yes BinaryKey=RemoveOldGuruContentSql SqlDb=SqlDatabase/ sql:SqlScript Id=Upgrade ExecuteOnInstall=yes BinaryKey=UpgradeSql SqlDb=SqlDatabase/ sql:SqlScript Id=AddCompleteMedia ExecuteOnInstall=yes BinaryKey=AddCompleteMediaSql SqlDb=SqlDatabase/ sql:SqlScript Id=InstallGuruContent ExecuteOnInstall=yes BinaryKey=InstallGuruContentSql SqlDb=SqlDatabase/ sql:SqlScript Id=UpdateCustomPlayList ExecuteOnInstall=yes BinaryKey=UpdateCustomPlayListSql SqlDb=SqlDatabase/ sql:SqlScript Id=InstallFeaturedContent ExecuteOnInstall=yes BinaryKey=InstallFeaturedContentSql SqlDb=SqlDatabase/ /Component I have installed SQL Management Studio on my test machine. After the installation I logged on using the 'sa' user and manually created the mvdb database without a problem. I have also uploaded the complete verbose log but I don't see anything else that could be the cause of the problem. Thanks, Gary serverinstall.log http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/file/n7597803/serverinstall.log -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Error-database-does-not-exist-when-executing-ExecuteSQLStrings-tp7597477p7597803.html Sent from the wix-users mailing list archive at Nabble.com. -- ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[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 I created a bundle. I have tested both of these and they install properly. Now I would like to create a new msi with a feature set that when the client is selected it executes the client msi and when both are selected it executes both the msi and the server bundle exe. I was unable to get any help when I asked this in August. Is this possible and does anyone have an example? If not does anyone have any suggestions? Thanks for the help, Gary -- 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-tp7598468.html Sent from the wix-users mailing list archive at Nabble.com. -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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 -- 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-tp7598468p7598470.html Sent from the wix-users mailing list archive at Nabble.com. -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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 archive at Nabble.com. -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[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 from the license agreement to the options (if the license was agreed to) and then have a button to install from there based on the option selected. Most of the posts talk about a UI statement but it doesn't seem to be valid for a bundle. Can you change the sequence of the UI in a bundle? Thanks, Gary -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Always-show-the-option-dialog-tp7598481.html Sent from the wix-users mailing list archive at Nabble.com. -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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 archive at Nabble.com. -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[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 ExePackage Cache=no InstallCondition=INSTALLSERVER Description=SQL Server and Server Bundle Id=GuruServer SourceFile=ServerSQLBundle.exe /ExePackage RtfTheme.xml Page Name=Options Text X=11 Y=80 Width=-11 Height=30 FontId=2 DisablePrefix=yes#(loc.OptionsHeader)/Text Text X=11 Y=120 Width=-11 Height=30 FontId=3 DisablePrefix=yes#(loc.OptionsDescription)/Text *Checkbox Name=INSTALLSERVER X=11 Y=166 Width=260 Height=17 TabStop=yes FontId=3Install Guru Server/Checkbox* Button Name=OptionsOkButton X=229 Y=-11 Width=75 Height=23 TabStop=yes FontId=0#(loc.OptionsOkButton)/Button Button Name=InstallButton X=314 Y=-11 Width=75 Height=23 TabStop=yes FontId=0#(loc.InstallInstallButton)/Button Button Name=WelcomeCancelButton X=404 Y=-11 Width=75 Height=23 TabStop=yes FontId=0#(loc.InstallCloseButton)/Button /Page Thanks, Gary -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Install-condition-is-not-being-set-in-options-dialog-tp7598513.html Sent from the wix-users mailing list archive at Nabble.com. -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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 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 ExePackage Cache=no InstallCondition=INSTALLSERVER Description=SQL Server and Server Bundle Id=GuruServer SourceFile=ServerSQLBundle.exe /ExePackage RtfTheme.xml Page Name=Options Text X=11 Y=80 Width=-11 Height=30 FontId=2 DisablePrefix=yes #(loc.OptionsHeader) /Text Text X=11 Y=120 Width=-11 Height=30 FontId=3 DisablePrefix=yes #(loc.OptionsDescription) /Text * Checkbox Name=INSTALLSERVER X=11 Y=166 Width=260 Height=17 TabStop=yes FontId=3 Install Guru Server /Checkbox * Button Name=OptionsOkButton X=229 Y=-11 Width=75 Height=23 TabStop=yes FontId=0 #(loc.OptionsOkButton) /Button Button Name=InstallButton X=314 Y=-11 Width=75 Height=23 TabStop=yes FontId=0 #(loc.InstallInstallButton) /Button Button Name=WelcomeCancelButton X=404 Y=-11 Width=75 Height=23 TabStop=yes FontId=0 #(loc.InstallCloseButton) /Button /Page Thanks, Gary -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Install-condition-is-not-being-set-in-options-dialog-tp7598513p7598518.html Sent from the wix-users mailing list archive at Nabble.com. -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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: Setting numeric variable 'EulaAcceptCheckbox' to value 1 [022C:2E6C][2014-12-10T16:51:35]i000: Setting numeric variable 'EulaAcceptCheckbox' to value 1 [022C:5B60][2014-12-10T16:51:35]i200: Plan begin, 2 packages, action: Install [022C:5B60][2014-12-10T16:51:35]i052: Condition 'InstallServer = 1' evaluates to false. [022C:5B60][2014-12-10T16:51:35]w321: Skipping dependency registration on package with no dependency providers: Server I'd almost think that it wasn't using my theme file except that the option dialog displays with the checkbox and text in the theme file. I'm wondering why the EulaAcceptCheckbox is displayed twice? Thanks, Gary -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Re-Install-condition-is-not-being-set-in-options-dialog-P-tp7598521p7598524.html Sent from the wix-users mailing list archive at Nabble.com. -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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? Thanks, Gary -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Re-Install-condition-is-not-being-set-in-options-dialog-P-tp7598521p7598531.html Sent from the wix-users mailing list archive at Nabble.com. -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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 Publish\Guru\Dependencies\License.rtf ThemeFile=gururtftheme.xml LogoFile=images\guru-dental.png LocalizationFile=1033\gururtftheme.wxl/ Payload Name=gururtftheme.wxl SourceFile=1033\gururtftheme.wxl / Payload Name=guru-dental.png SourceFile=images\guru-dental.png/ /BootstrapperApplicationRef Variable Name=InstallServer Type=numeric bal:Overridable=yes Value=0 / Chain ExePackage Cache=no InstallCondition=InstallServer = 1 Description=SQL Server and Guru Server Bundle Id=GuruServer SourceFile=\\SERVER\RedirectedFolders\gary.monk\My Documents\Visual Studio 2013\Projects\Guru Install Solution\GuruSQLBundle\bin\Debug\GuruSQLBundle.exe /ExePackage MsiPackage Cache=no Description=Guru Client Id=GuruClient DisplayInternalUI=yes SourceFile=\\SERVER\RedirectedFolders\gary.monk\My Documents\Visual Studio 2013\Projects\Guru Install Solution\GuruClientInstall\bin\Debug\GuruClientInstall.msi / /Chain /Bundle Theme... Page Name=Install Richedit Name=EulaRichedit X=11 Y=80 Width=-11 Height=-70 TabStop=yes FontId=0 HexStyle=0x80 / Checkbox Name=EulaAcceptCheckbox X=-11 Y=-41 Width=260 Height=17 TabStop=yes FontId=3 HideWhenDisabled=yes#(loc.InstallAcceptCheckbox)/Checkbox Text X=11 Y=-11 Width=260 Height=17 FontId=3#(loc.InstallVersion)/Text Button Name=OptionsButton X=-91 Y=-11 Width=75 Height=23 TabStop=yes FontId=0 HideWhenDisabled=yes#(loc.InstallOptionsButton)/Button Button Name=WelcomeCancelButton X=-11 Y=-11 Width=75 Height=23 TabStop=yes FontId=0#(loc.InstallCloseButton)/Button /Page Page Name=Options Text X=11 Y=80 Width=-11 Height=30 FontId=2 DisablePrefix=yes#(loc.OptionsHeader)/Text Text X=11 Y=120 Width=-11 Height=30 FontId=3 DisablePrefix=yes#(loc.OptionsDescription)/Text Checkbox Name=InstallServer X=180 Y=180 Width=-11 Height=17 FontId=3 TabStop=yes HideWhenDisabled=no#(loc.ServerInstallCheckbox)/Checkbox Button Name=OptionsOkButton X=229 Y=-11 Width=75 Height=23 TabStop=yes FontId=0#(loc.OptionsOkButton)/Button Button Name=InstallButton X=314 Y=-11 Width=75 Height=23 TabStop=yes FontId=0#(loc.InstallInstallButton)/Button Button Name=WelcomeCancelButton X=404 Y=-11 Width=75 Height=23 TabStop=yes FontId=0#(loc.InstallCloseButton)/Button /Page What I'm trying to do is to have the option for installing server always be displayed without the user having to click on a button. After displaying the server option there isn't any point to going back to the welcome page. Thanks for the help! Gary -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Re-Install-condition-is-not-being-set-in-options-dialog-P-tp7598521p7598533.html Sent from the wix-users mailing list archive at Nabble.com. -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[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 Client Only/Button Button Name=ServerInstall X=160 Y=155 Width=-11 Height=17 TabStop=yes FontId=3 HexStyle=0x04Guru Teach Client and Server/Button Text X=110 Y=200 Width=300 Height=30 FontId=3 DisablePrefix=yes#(loc.OptionsDescription)/Text Hypertext Name=EulaHyperlink X=11 Y=-61 Width=-11 Height=51 TabStop=yes FontId=3 HideWhenDisabled=yes#(loc.InstallLicenseLinkText)/Hypertext Checkbox Name=EulaAcceptCheckbox X=-11 Y=-41 Width=260 Height=17 TabStop=yes FontId=3 HideWhenDisabled=yes#(loc.InstallAcceptCheckbox)/Checkbox Text X=11 Y=-11 Width=260 Height=17 FontId=3#(loc.InstallVersion)/Text Button Name=InstallButton X=-91 Y=-11 Width=75 Height=23 TabStop=yes FontId=0#(loc.InstallInstallButton)/Button Button Name=WelcomeCancelButton X=-11 Y=-11 Width=75 Height=23 TabStop=yes FontId=0#(loc.InstallCloseButton)/Button /Page The problem is you cannot select either radio button. I've played around with the HexStyle values but they're either grayed out (9) or unusable (4). http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/file/n7598537/hyperlink.png How do I make the buttons usable and set a variable(s) to either 0 or 1 based on whether the button is selected? Thanks, Gary -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-select-radio-buttons-in-Hyperlink-Theme-tp7598537.html Sent from the wix-users mailing list archive at Nabble.com. -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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 HexStyle=0x09Guru Teach Client Only/Button Button Name=ServerInstall X=160 Y=155 Width=-11 Height=17 TabStop=yes FontId=3 HexStyle=0x09Guru Teach Client and Server/Button and the buttons are disabled when the dialog is displayed. How do I make the buttons enabled? Thanks, Gary -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-select-radio-buttons-in-Hyperlink-Theme-tp7598537p7598543.html Sent from the wix-users mailing list archive at Nabble.com. -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Re-Unable-to-select-radio-buttons-in-Hyperlink-Theme-P-tp7598544p7598547.html Sent from the wix-users mailing list archive at Nabble.com. -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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 bal:WixStandardBootstrapperApplication LicenseUrl=C:\VS Publish\Guru\Dependencies\License.txt ThemeFile=guruhyperlinktheme.xml LogoFile=images\guru.ico LocalizationFile=1033\guruhyperlinktheme.wxl/ Payload Name=guruhyperlinktheme.wxl SourceFile=1033\guruhyperlinktheme.wxl / Payload Name=guru.ico SourceFile=images\guru.ico/ /BootstrapperApplicationRef Variable Name=InstallClient Type=numeric bal:Overridable=yes Value=1 / Variable Name=InstallServer Type=numeric bal:Overridable=yes Value=0 / Chain ExePackage Cache=no InstallCondition=InstallServer = 1 Description=SQL Server and Guru Server Bundle Id=GuruServer SourceFile=\\SERVER\RedirectedFolders\gary.monk\My Documents\Visual Studio 2013\Projects\Guru Install Solution\GuruSQLBundle\bin\Debug\GuruSQLBundle.exe /ExePackage MsiPackage Cache=no Description=Guru Client Id=GuruClient DisplayInternalUI=yes SourceFile=\\SERVER\RedirectedFolders\gary.monk\My Documents\Visual Studio 2013\Projects\Guru Install Solution\GuruClientInstall\bin\Debug\GuruClientInstall.msi / /Chain /Bundle Thanks, Gary -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-select-radio-buttons-in-Hyperlink-Theme-tp7598537p7598548.html Sent from the wix-users mailing list archive at Nabble.com. -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-select-radio-buttons-in-Hyperlink-Theme-tp7598537p7598559.html Sent from the wix-users mailing list archive at Nabble.com. -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Re-Unable-to-select-radio-buttons-in-Hyperlink-Theme-P-tp7598544p7598563.html Sent from the wix-users mailing list archive at Nabble.com. -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[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} SourceFile=..\Prerequisites\QuickTimeInstaller.exe Name=Prerequisites\QuickTimeInstaller.exe Permanent=yes DisplayName=Apple QuickTime 7 InstallCondition=NOT Installed /ExePackage As you can see the install condition is NOT installed. Why would QuickTime install even when the install condition says it should only be installed when it is not installed? 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-tp7600756.html Sent from the wix-users mailing list archive at Nabble.com. -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/ ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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 wix-users mailing list archive at Nabble.com. -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/ ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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 [08B4:040C][2015-07-06T10:50:14]i000: Registry key not found. Key = 'HKEY_LOCAL_MACHINE\SOFTWARE\Clients\Media\QuickTime' My registry... http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/file/n7600799/Capture.png My code... util:RegistrySearch Root=HKLM Key=HKEY_LOCAL_MACHINE\SOFTWARE\Clients\Media\QuickTime Result=exists Variable=QuickTimeFound64 Win64=yes / util:RegistrySearch Root=HKLM Key=HKEY_LOCAL_MACHINE\SOFTWARE\Clients\Media\QuickTime Result=exists Variable=QuickTimeFound32 Win64=no / Chain PackageGroupRef Id=PackageGroup_NetFx35Redist/ PackageGroupRef Id=PackageGroup_NetFx40Redist/ PackageGroupRef Id=PackageGroup_SQLServer2012/ ExePackage Id=Package_QuickTime Cache=no Compressed=$(var.Compressed) Description=Apple QuickTime 7 DownloadUrl=$(var.GuruDownloadRepo)/{2} SourceFile=..\Prerequisites\QuickTimeInstaller.exe Name=Prerequisites\QuickTimeInstaller.exe Permanent=yes DisplayName=Apple QuickTime 7 DetectCondition=QuickTimeFound64 AND QuickTimeFound32 / The way I think this should work is that QuickTime32 is false and QuickTime64 should be true, but as you can see from the log it still comes back as false. I have tried including Wow6432Node in the 64bit path but it didn't make any difference. I would appreciate any help!! -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/QuickTime-is-installing-when-it-is-already-installed-tp7600756p7600799.html Sent from the wix-users mailing list archive at Nabble.com. -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/ ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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 list archive at Nabble.com. -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/ ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users