2 replies to this topic

[DenMori]

Here's something that seems simple, but doesn't want to cooperate!

I have a Basic MSI project with a single SQL connection, customized SQLDatabase dialogs to allow me to select multiple databases; and scripts that are associated with the SQL connection. They are linked to a "Support Files" feature which is required for installation. My server name and database selections are picked up correctly (I see this in the install log), but for some unknown reason the scripts do not appear to be running at all. The scripts are tagged to stop the installation on an error. SQL scripts run ok via Query Analyzer, so I know there are no syntax issues.

I have used this functionality in a prior project without a problem, so I'm a bit puzzled by this issue.


What can I look at that might point me in the right direction?

(PS: On an unrelated note, this setup also will not uninstall via Add/Remove Programs..I have to use the MSIZap utilities to remove its entries from the Installer database)

[Stefan Krueger]

I would recommend fixing the uninstall problem first. Then test again on a clean machine (fresh OS image, empty database). The SQL problem may be a side effect.

[DenMori]

There must have been something corrupted in the project. I deleted it and recreated it from scratch and the scripts run fine now.

The next battle is getting them to run conditionally based on whether or not the script had changed since the last run.

I have been told I cannot change the scripts themselves.