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

Reply via email to