Can anybody figure out why database is not created using the codes below
(when Database is chosen to be installed in Custom Option)? Thanks!!!!!
<?xml version="1.0" encoding="UTF-8"?>
<Wix xmlns="http://schemas.microsoft.com/wix/2003/01/wi";>
<Product Id="GUID" UpgradeVode ="GUID" Name="Application 1.0"
Language="1033"
Version="1.0.0.0" Manufacturer="CompanyName" Codepage="1252">
<Package Id="????????-????-????-????-????????????" Keywords="Installer"
Descriptin="Installer" Comments="Comments" InstallerVersion="200"
Compressed="yes" Manufacturer="CompanyName"
Languages="1033" SummaryVodepage="1252"/>
...
<!-- User for Database -->
<User Id="SQLUser" Name="[SQLUSER]" Password="[SQLPASSWORD]" />
<!-- Installatin Folders -->
<Directory Id="TARGETDIR" Name="SourceDir">
<Directory Id="ProgramFilesFolder" Name="PFiles">
<Directory Id="INSTALLDIR" Name="TestDir" LongName="TestDir">
<!-- Database -->
<Directory Id="Database" Name="Database" >
<Component Id="DBComponent" Guid="GUID">
<SqlDatabase Id="DBDatabase" Database="TestDB" User="SQLUser"
Server="[SQLSERVER]"
CreateOnInstall="yes" DropOnUninstall="yes"
ContinueOnErrr="yes" ConfirmOverwrite="no">
<SqlScript Id="Create_Table" BinaryKey="Create_Table"
ExecuteOnInstall="yes" />
<SqlScript Id="Create_SP" BinaryKey="Create_SP"
ExecuteOnInstall="yes" />
</SqlDatabase>
</Component>
</Directory>
.....
</Directory>
</Directory>
</Directory>
<!-- End of TargetDir -->
<!-- Database Files -->
<Binary Id="Create_Table" SourceFile="Create_Table.sql" />
<Binary Id="Create_SP" SourceFile="Create_SP.sql" />
<!-- Custom Settings -->
<Feature Id="Complete" Title="Application 1.0" Level="1"
Descriptin="The complete package" Display="expand"
ConfigurableDirectory="INSTALLDIR">
....
<!-- Database -->
<Feature Id="SqlFeature" Title="Database" Level="1000">
<ComponentRef Id="DBComponent" />
</Feature>
</Feature>
<Property Id="INSTALLLEVEL">3</Property>
<!-- Database user -->
<Property Id="SQLUSER">username</Property>
<Property Id="SQLPASSWORD">password</Property>
<Property Id="SQLSERVER">127.0.0.1</Property>
..
</Product>
</Wix>
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
