Loading
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!

  • 0_H Yamanishi (Flexera Software)

    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.
    Expand Post
  • Thank you for the suggestion. I created documentation issue IOC-000066337 to log the documentation improvement request.

     

    Debbie Landers

     

    Macrovision Corporation
    Expand Post

Loading
Conditional statements for SQL scripts that are run during installation