This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- SQL Scripts not running - why?
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Aug 12, 2013
04:57 PM
SQL Scripts not running - why?
Hello, I created an InstallScript installer project, and amongst it's other features/components, it has two SQL Server scripts to run. I added these under "Server Configuration/SQL Scripts", by creating an SQLConnection and then on that connection selecting "Insert Script Files...".
But the SQL scripts are not being executed!
I tried creating just a simplistic installer, with a simple SQL script added in the same manner, with the same parameters for the SQLConnection. That one does execute - I can see the results of what it does within SQL Server. But in my actual installer project, the scripts don't run. And nothing in the log file indicates why.
When should the scripts run, before or after the files are copied over? What would prevent them from executing?
I'm trying to use InstallShield Premier 2012 Spring, on Windows Server 2008. The SQL is going against SQL Server 2008.
Thank you for any help or hints,
James
But the SQL scripts are not being executed!
I tried creating just a simplistic installer, with a simple SQL script added in the same manner, with the same parameters for the SQLConnection. That one does execute - I can see the results of what it does within SQL Server. But in my actual installer project, the scripts don't run. And nothing in the log file indicates why.
When should the scripts run, before or after the files are copied over? What would prevent them from executing?
I'm trying to use InstallShield Premier 2012 Spring, on Windows Server 2008. The SQL is going against SQL Server 2008.
Thank you for any help or hints,
James
(1) Reply
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Aug 14, 2013
04:46 PM
I would suggest that you debug your InstallScript code and make sure that the OnSQLServerInitialize() and OnSQLComponentInstalled() functions are executed.