Hi!
I have the follow .wxs.
I use the UIRef Id="WixUI_Common" thing.
I run the .msi, I chose to have the database file to install c:\ then
sometimes I got an permission error that says I cannt install in c:\,
but if I rerun and try to install somewhere else, like c:\tmp, then it
runs fine.
Install C:\
Error -214721900: failed to create SQL database: BizTalkWMdataLog, error
detail: CREATE FILE encounterd operation system error 5(Aces is denied)
while attmemting to open or create the physical file
'C:\BizTalkWMdataLog.mdf'
If the database already exist and I run the install, the installer will
ask me if I like to Continue.. overwrite I guess?. I answer No. But then
it removes the existing database....
I have just started to play around with this SQL things and I have
noticed some other mails about this area.....
<?xml version="1.0" encoding="UTF-8"?>
<Wix xmlns="http://schemas.microsoft.com/wix/2006/wi"
xmlns:sql="http://schemas.microsoft.com/wix/SqlExtension">
<Fragment>
<!-- TODO: Put your code here. -->
<DirectoryRef Id="TARGETDIR">
<Directory
Id="INSTALLLOCATION_DB">
<Component Id="WMdataLoggingDatabaseComponent"
Guid="{AC9CE92B-0AFE-4cd4-B48C-E82D999C1250}">
<CreateFolder/>
<sql:SqlDatabase Id="BizTalkWMdataLog"
Server ="."
Database="BizTalkWMdataLog"
CreateOnInstall ="yes"
ConfirmOverwrite ="yes"
DropOnInstall ="no">
<sql:SqlFileSpec Id="BizTalkWMdataLog"
Name="BizTalkWMdataLog"
Filename="[INSTALLLOCATION_DB]BizTalkWMdataLog.mdf"
Size="20MB"/>
<sql:SqlLogFileSpec Id="BizTalkWMdataLog_Log"
Name="BizTalkWMdataLog_Log"
Filename="[INSTALLLOCATION_DB]BizTalkWMdataLog_Log.ldf"
Size="10MB"/>
</sql:SqlDatabase>
</Component>
</Directory>
</DirectoryRef>
</Fragment>
</Wix>
************* AND ***********************
<Feature Id="FeatureLoggingDatabase" Title="Database for Logging"
Description="Database for Logging" Level="1000"
ConfigurableDirectory="INSTALLLOCATION_DB">
<ComponentRef Id="WMdataLoggingDatabaseComponent" />
</Feature>
/cj
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users