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
- :
- Conditional statements for SQL scripts that are run during installation
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
‎Nov 21, 2007
11:28 AM
Conditional statements for SQL scripts that are run during installation
Hello!
There are two SQL connections in the InstallShield project which require Oracle and Microsoft SQL Server.
I have done the test project to check how the SQL Connections are called regarding to conditions. See the attachment.
Why after connection verification to the SQL Server the Oracle connection is checked up?
How do the conditional statements work for SQL scripts?
Thank You!
There are two SQL connections in the InstallShield project which require Oracle and Microsoft SQL Server.
I have done the test project to check how the SQL Connections are called regarding to conditions. See the attachment.
Why after connection verification to the SQL Server the Oracle connection is checked up?
How do the conditional statements work for SQL scripts?
Thank You!
(3) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Nov 21, 2007
12:31 PM
In Basic MSI and InstallScript MSI projects, InstallShield will validate all connections included in a setup by default when you click the Next button on the SQLLogin dialog. If you want to validate only a particular connection, you need to set the name of the connection to the IS_SQLSERVER_CONNECTIONS_TO_VALIDATE property. In your case, you need to have the following control event entries for the Next button of the InstallWelcome dialog.
[IS_SQLSERVER_CONNECTIONS_TO_VALIDATE] NewSQLConnection_SQLServer TEST=1
[IS_SQLSERVER_CONNECTIONS_TO_VALIDATE] NewSQLConnection_Oracle TEST=0
Hope that helps.
[IS_SQLSERVER_CONNECTIONS_TO_VALIDATE] NewSQLConnection_SQLServer TEST=1
[IS_SQLSERVER_CONNECTIONS_TO_VALIDATE] NewSQLConnection_Oracle TEST=0
Hope that helps.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Nov 22, 2007
04:57 AM
Thank you for reply!
It helped!
Why so few information in the Help about using Multiple SQLLogin Dialogs and, especially, about IS_SQLSERVER_CONNECTIONS_TO_VALIDATE property?
I found a good article: HOWTO: Create and Use Multiple SQLLogin Dialogs
http://support.installshield.com/kb/view.asp?articleid=Q111493
It would be better to include this information into the Help topics.
Thank you very much!
It helped!
Why so few information in the Help about using Multiple SQLLogin Dialogs and, especially, about IS_SQLSERVER_CONNECTIONS_TO_VALIDATE property?
I found a good article: HOWTO: Create and Use Multiple SQLLogin Dialogs
http://support.installshield.com/kb/view.asp?articleid=Q111493
It would be better to include this information into the Help topics.
Thank you very much!
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Nov 26, 2007
07:37 AM
Thank you for the suggestion. I created documentation issue IOC-000066337 to log the documentation improvement request.
Debbie Landers
Macrovision Corporation
Debbie Landers
Macrovision Corporation
![](/skins/images/8C9D13A71C7F7695F3262372C0172D68/responsive_peak/images/icon_anonymous_message.png)