Adding a SQLLogin Predefined Wizard Page in a Suite/Advanced UI Project

InstallShield 2020

Project:This information applies to the Suite/Advanced UI project type.

Edition:The Suite/Advanced UI project type is available in the Premier edition of InstallShield. For information about the differences between these two project types, see Advanced UI Projects vs. Suite/Advanced UI Projects.

SQL servers are integral to many applications, especially those that benefit from the multiple package support provided by InstallShield Suite installations. Previously, InstallShield SQL support was limited to Basic MSI, InstallScript, and InstallScript MSI projects. Now, SQL support has been added to Suite/Advanced UI projects, giving you the ability to:

•

Add a new SQLLogin predefined wizard page

•

Execute SQL statements directly from Suites

The SQLLogin wizard page lets end users enter database server login information (database server name, authentication credentials, database catalog name, etc.) in order to establish a connection to the database server that is targeted by one or more .msi packages in the suite.

Adding a SQLLogin wizard page to your project allows you to:

•

Specify properties that identify the SQL login settings in the Suite project and then select the .msi package that receives these properties

•

Specify the properties that identify the SQL login settings in the .msi package

•

Choose the database technology (Microsoft SQL Server, Microsoft Windows Azure, MySQL, or Oracle) and select the ODBC driver to be targeted

•

Ensure that updated SQL drivers will be scheduled for installation via an action in OnBegin

In addition, Suite/Advanced UI projects now support directly executing SQL statements on SQL database servers from the user interface, helping to examine SQL database servers before proceeding the installation. The SQL query result can then be accessed in a Suite property.

The following shows how to add a SQLLogin predefined wizard page to your project. Alternatively, you can manually configure SQL support in your Suite project in order to customize the UI based upon your installation’s needs.

To add a SQLLogin predefined wizard page and optionally execute a SQL statement directly in a Suite/Advanced UI project:

1.

In the View List under User Interface, click Wizard Interface.

2.

In the Wizard Interface explorer, right-click Wizard Pages and then click Add Predefined Page. The User Interface Wizard opens.

3.

In the Task page list, select Enter login information for a database server.

4.

In the Subsequent page list, indicate where in the wizard page sequence you want to schedule the database server wizard page. The page that you select in this list will be displayed immediately after the new database server wizard page at run time.

5.

In the Task Configuration panels in the User Interface Wizard:

a.

Specify properties that identify the SQL login settings in the Suite project.

Note:A suite project may have multiple packages that require different SQL servers or they may need to share.

b.

Select the .msi package that receives the properties.

c.

Choose the database technology and driver.

InstallShield adds corresponding Page Entered settings for the Task Configuration properties you specify.

6.

To optionally add a SQL statement to be directly executed from the Suite/Advanced UI project at runtime, add a Run a SQL String action to your project and specify its subsettings as needed. The SQL query result will be accessible from the Suite property that you specify in the Data Property subsetting.

See Also

Sequencing Wizard Pages

User Interface Wizard

Wizard Interface View