Requirements Tab

InstallShield 2019 » SQL Scripts View » SQL Connection

Project • The SQL Scripts view is available in the following project types:

On the Requirements tab, you can select a database server and specify version requirements for the type of server that the installation should target at run time. You have the option to add, delete, or edit existing version requirements that are associated with a particular database server.

To select a database server and specify version requirements for the type of server that the installation will target at run time:

If you select more than one database server, at run time, the installation establishes a connection and performs the specified requirement checks on the selected server types based on the sequence of the server types as they appear in the table. That is, if the installation finds a match after checking requirements against the first database server in the table, a connection and a check is not done on any selected subsequent database types in the table. The SQL scripts that are associated with the connection are installed to that first database server that is verified.

InstallShield adds a new database server entry and its appropriate version information to the table next to the Database Servers list.

To delete or edit an entry in the Database Servers table:

Note • Multiselection of items in the version requirements section of the table applies only to the Delete operation.

Allow installation to continue when minimum requirements are not met

If you want to allow the installation to continue if the minimum database server requirements are not met, select this check box.

If you select this check box and the minimum requirements are not met, the installation skips the SQL connection and all of its SQL scripts, and continues with the rest of the installation.

If you clear this check box and the minimum requirements are not met, the installation does not allow the end user to continue with the rest of the installation.

This check box is cleared by default.

Allow installation to Microsoft SQL Server Desktop Engine/SQL Server Express

Select this check box if it is true. Clear this check box if you want to prohibit installation to SQL Server Desktop Engine and SQL Server Express.

Choose SQL Driver for Database Server

In InstallShield 2019 R3 and later, you can now choose a different provider from a list of drivers for your database server. The Connection string properties (present in the ISSQLDBMetaData table) are automatically updated based on the provider selection.

By default, the Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) will appear for your new SQL connection. The following prerequisites are automatically added to your project configuration when MSOLEDBSQL is selected:

Select the Redistributables view to download or configure required prerequisites.

See Also

SQL Scripts View

General Tab

Advanced Tab

Open topic with navigation