cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
iansuy
Level 2

InstallShield 2010 SQL Script multi line comment bug?

I think I found a bug with multi-line comments and SQL scripts in InstallShield 2010.

To reproduce the bug, create a basic MSI project. Go to Installation Designer -> SQL Scripts, create a SQL connection then add a new script that contains the following script:

/*
USE [master]
GO
*/

USE master
GO

Build the MSI and try to install it, you will receive the following MSI error:

Error 27506.Error executing SQL script sqlscript.sql. Line 3. Missing end comment mark '*/'. (113)

Changing the multi-line comment to -- form will solve the issue. Also, if the end comment mark is not being preceded by a GO statement, the install will not fail. For instance:

/*
THIS
WILL
NOT
FAIL
*/

Has someone experienced this bug? Any way to "fix" it?
Labels (1)
0 Kudos
(1) Reply
mloebl
Level 4

I don't think I've seen this yet, but we did run into length limitation issues with Installshield with the identical error, and their support had confirmed it was too large for IS to handle. Our DBA had commented out a large block as they were testing a new section. The giant blocked caused an overrun (worked fine in SQL Mgmnt Studio.)

-Mike
0 Kudos