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

Reply via email to