View Full Version : Which SQL client does IS use to run sql scripts in SQLExpress

02-28-2008, 04:04 AM
Does anyone know which SQL Client/Command InstallShield uses to execute an SQL script in case of an SQLExpress engine?

I have a script running fine in sqlcmd, but when it is called during installation, it reports syntax errors. Changing the script and rebuilding the setup.exe is quite time consuming, so an alternative would be welcome.

02-28-2008, 02:31 PM
Would it be possible for you to email me your SQL script at hidenoriy@macrovision.com? I will look into it to see what's causing the problem.

02-29-2008, 06:59 AM
I found the problem.

I was using the text replacement feature for the SQL scripts to replace some strings with properties. Some of these properties where however not set during a repair or update installation.

03-26-2008, 01:45 PM
I am having a similar problem, except that mine is erroring on an "ENABLE TRIGGER" command....