Rui Fan (MDT InfoTech) wrote: > Error 26204. Error -2147217900: failed to execute SQL string, error detail: > Incorrect syntax near the keyword 'with'. …… > MSI (s) (68!24) [15:49:56:154]: Product: Microsoft MAA - Core Database -- > Error 26204. Error -2147217900: failed to execute SQL string, error detail: > Incorrect syntax near the keyword 'with'. If this statement is a common table > expression, an xmlnamespaces clause or a change tracking context clause, the > previous statement must be terminated with a semicolon., SQL key: > CoreDBSBSQLScript SQL string: riginal error information. > …… >
The error message is coming from SQL, not the custom action. You'll have better luck debugging the SQL strings. > I found a function called “ExecuteSqlStrings” under serverca\scaexec. I can’t > find the generated scaexec.dll in wix3-binaries.zip. It's embedded in WixSqlExtension.dll. If you want to debug the code, you'll need to rebuild the scaexec.dll and WixSqlExtension.dll. -- sig://boB http://joyofsetup.com/ ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ WiX-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/wix-users
