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'>
<Condition>USEINTEGRATEDSECURITY = 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
