I need to create a database named (for example) >test._db<
If i write it like this
<sql:SqlDatabase Id="SqlDatabaseSql" User="SqlUser"
Database="[\[][CREATEDBNAME][\]]" Server="[CREATEHOSTNAME]"
CreateOnInstall="yes" CreateOnReinstall="yes" CreateOnUninstall="no"
ContinueOnError="no" DropOnInstall="no" DropOnReinstall="no"
DropOnUninstall="no">
Where [CREATEDBNAME] is a property with value of >test._db< It creates
the database ok, but when i try to execute any of the <sql:SqlScript> or
<sql:SqlString>
For example:
<sql:SqlScript Id="CreateTablesSql" User="SqlUser"
BinaryKey="CreateTables" Sequence="1" ExecuteOnInstall="yes"
ExecuteOnReinstall="yes" ExecuteOnUninstall="no" ContinueOnError="no" />
where CreateTables is a binary id and source is .sql file with the
script i need to run on new database,
it returns an error
Error 26203. Failed to connect to SQL database. (-2147467259
[test._db] )
Any help about how to create database with strange names and run scripts
in it is appreciated. Could be that i'm just escaping characters wrong
somehow.
Thank you
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users