PDA

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



tcom36
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.

hidenori
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.

tcom36
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.

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