Specifying Whether New SQL Connections Should Share the Same Windows Installer Properties

InstallShield lets you specify whether new SQL database connections that you add to your project should share the same Windows Installer properties by default.

For example, if you want connections to share the same default Windows Installer properties, you could add one connection to your project in the SQL Scripts view, and specify a catalog name of MyConnection. If you add a second connection to your project, InstallShield uses the same catalog name of MyConnection for that second connection. If you change the catalog name of either connection, InstallShield automatically updates the catalog name of the other connection, since both are based on the same Windows Installer property.

To specify whether SQL connections should share the same Windows Installer properties:

On the Tools menu, click Options. The Options dialog box opens.

Click the SQL Scripts tab.

Select or clear the Generate unique Windows Installer properties for new connections check box:

To share Windows Installer properties between any new connections that you add, clear this check box.

To use different Windows Installer properties for any new connections that you add, select this check box.

If you select the check box and then add a second connection to your project, InstallShield creates a new set of Windows Installer properties for the second connection.

If you clear the check box and then add a second connection, InstallShield uses the default Windows Installer properties for the second connection. The default Windows Installer properties are the ones that were added for the first connection that you added to your project.

If you want to override a Windows Installer property for an existing connection, add a new property in the Property Manager. Then, in the SQL Scripts view, select the connection. On the Advanced tab, select the name of the new property in the appropriate list.

For Basic MSI projects, the built-in SQLLogin dialog is designed to work with the default Windows Installer properties for the first SQL connection that was added to the project. If you select the Generate unique Windows Installer property for new connections option, you need to duplicate the dialog for each connection to work with the new Windows Installer properties.