We’re moving our forums to a new platform.

You can still browse and search existing topics, but you can no longer create new topics or post replies.

For questions, technical issues, or feature requests, please don’t hesitate to contact our support team at support@advancedinstaller.com.

Thank you for your understanding!

Terry
Posts: 14
Joined: Tue May 22, 2007 12:57 pm

SQL script with backslash fails

Using osql inside a Command Prompt window all our SQL scripts execute without any problems.

But put inside our installer project, it fails with the following error message-

[Microsoft][SQL Native Client][SQL Server]Incorrect syntax near 'GO'.

I have isolated the reason for this to a backslash character inside a SQL string literal.

Our SQL programmer is loathe to change this code and says it is an Advanced Installer bug. Is this something you can fix and if so when will it be fixed?
Cosmin
Posts: 5797
Joined: Tue Jul 10, 2007 6:39 pm
Contact: Website

Hi,

Please make sure you haven't forgot to configure "GO" as a separator inside the Advanced Installer project.

If the problem persists please send us the .aip and the SQL script (if it doesn't contain confidential information) or a small test case reproducing this behavior to support at advancedinstaller dot com so we can investigate the problem.

Regards,
Cosmin
Cosmin Pirvu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Return to “Common Problems”