Wix 3.0. If the name of SQL database contains '-' symbol then the error 
-2147217900 appears during installing.

Record in msi log: "CreateDatabase:  Error 0x80040e14: failed to create to 
database: 'Reports-001', error: Incorrect syntax near '-'."



To fix this problem following changes needed:

file: src\dutil\strutil.cpp



old string-447  hr = StrAllocFormatted(&pwzQuery, L"CREATE DATABASE %s %s%s 
%s%s", wzDatabase, pwzDbFile ? L"ON " : L"", pwzDbFile ? pwzDbFile : L"", 
pwzLogFile ? L"LOG ON " : L"", pwzLogFile ? pwzLogFile : L"");



new string+447  hr = StrAllocFormatted(&pwzQuery, L"CREATE DATABASE [%s] %s%s 
%s%s", wzDatabase, pwzDbFile ? L"ON " : L"", pwzDbFile ? pwzDbFile : L"", 
pwzLogFile ? L"LOG ON " : L"", pwzLogFile ? pwzLogFile : L"");





old string-518          hr = StrAllocFormatted(&pwzQuery, L"DROP DATABASE %s", 
wzDatabase);

new string+518          hr = StrAllocFormatted(&pwzQuery, L"DROP DATABASE 
[%s]", wzDatabase);

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
WiX-devs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/wix-devs

Reply via email to