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
- :
- Need to switch between sql scripts (sql server & oracle) based on property
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
Mar 19, 2012
11:18 AM
Need to switch between sql scripts (sql server & oracle) based on property
The web applications I am installing can run against either a SQL Server or Oracle database. I need to be able to determine which database the user has and then dynamically tell InstallShield what SQLscript to run, I know I can figure out how to determine which database is installed. My question is how do I configure the Feature/Component and tell InstallShield which script to use.
(1) Reply
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Mar 19, 2012
04:37 PM
Within a Custom Action I was able to read a config file using FileGrep() to see if it had the Connection setting for MS SQL Server. If it did I set a property to 1, otherwise I set it to 0. Under Server Configuration I added two files under my SQL Connection. Under each file I added a "Conditional Statement" that checked the property I updated in the Custom Action. This way only one SQL script will fire.
![](/skins/images/CC38E504FC9E1309DC48ACFEB4925670/responsive_peak/images/icon_anonymous_message.png)