Are you getting an error? Also, what does the msi log report about the
database creation? You might want to set ContinueOnError to no and then see
what happens.
Dana
On 4/11/07, Moni Chow <[EMAIL PROTECTED]> wrote:
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
-------------------------------------------------------------------------
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
