Has anyone been able to create the MDF and LDF paths when specifying a path via
command line?
<Component Id="SQLCOMPONENT" Guid="93C3B900-5746-4C95-8EEB-9570BF3F1389"
Directory="INSTALLLOCATION" KeyPath="yes" >
<util:User Id="SQLUser" Name="[CREATE_DATABASE_USERNAME]"
Password="[CREATE_DATABASE_PASSWORD]"/>
<sql:SqlDatabase Id="SQLDatabase" Database="DB" User="SQLUser"
Server="[DATABASE_SERVER]"
CreateOnInstall="yes" CreateOnUninstall="no" CreateOnReinstall="no"
ConfirmOverwrite="no"
DropOnInstall="no" DropOnReinstall="no" DropOnUninstall="no"
ContinueOnError="no">
<sql:SqlFileSpec Id="Mdf" Name="Data" Filename="[MDFPATH]DB_Data.MDF"/>
<sql:SqlLogFileSpec Id="Ldf" Name="log" Filename="[LDFPATH]DB_log.LDF"/>
</sql:SqlDatabase>
<CreateFolder/>
</Component>
I've tried adding the <CreateFolder/> method but it will not create the folder.
However, if the folder path exists it works. I would like the end user to be
able to create whatever folder path they want when installing via command line.
i.e.
Installer.msi CREATE_DATABASE_USERNAME="user"
CREATE_DATABASE_PASSWORD="password" DATABASE_SERVER="IP Address"
LDFPATH="C:\DB" MDFPATH="C:\DB" /l*v c:\DB.log
I continue to get Error -2147217900: failed to create SQL database: DB, error
detail: CREATE DATABASE failed. Some file names listed could not be created.
Check related errors.
Thank you in Advance,
Jeremiah
------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr
_______________________________________________
WiX-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/wix-users
