Advanced Tab
InstallShield 2024 » SQL Scripts View » SQL Connection
Project:
| • | Basic MSI |
| • | DIM |
| • | InstallScript |
| • | InstallScript MSI |
The Advanced tab provides advanced settings that should be set only by expert users to expand and customize the default functionality that is available in InstallShield.
|
Setting |
Project Type |
Description |
|||||||||
|
Command Timeout (seconds) |
Basic MSI, DIM, InstallScript, InstallScript MSI |
Specify the command timeout period. The default is 30 seconds. The valid range of this value is 0 to 2147483647. A value of 0 indicates no limit. Once this period of time has elapsed without completing the command, an error occurs and ADO cancels the command. |
|||||||||
|
Batch Separator |
Basic MSI, DIM, InstallScript, InstallScript MSI |
Specify the appropriate batch separator for the selected connection. The batch separator is used for all SQL scripts that are associated with this connection. The default value is GO, which is the same default that is used in Microsoft products. Oracle utilities use a slash (/) as the default value. A batch separator is a command that is recognized by SQL utilities such as osql, isql, and Microsoft SQL Server Management Studio, as well as InstallShield. The run time interprets a batch separator as a signal that it should send the current batch of SQL statements to a database server. Note:A semicolon (;) is the only batch separator that does not need to be on a separate new line by itself. All other batch separators must be on a separate line. For example, if you specify a slash as a batch separator and you have the following SQL script, the installation sends some statement to a SQL server as a batch first; then it sends another statement as another batch: some statement / another statement / If you have the following script, the installation sends all of the lines, including the slashes at the end of lines, as a batch: some statement/ another statement/ |
|||||||||
|
Target Server Property Name |
Basic MSI, DIM, InstallScript MSI |
Select the property that identifies one of the following, depending on the type of database server that the installation is targeting:
The default property is IS_SQLSERVER_SERVER. If your project contains more than one SQL connection and you want to be able to use different properties for each connection, you can do so. For more information, see Specifying Whether New SQL Connections Should Share the Same Windows Installer Properties. |
|||||||||
|
Target Catalog Property Name |
Basic MSI, DIM, InstallScript MSI |
This setting enables you to select a property that identifies the name of the SQL catalog to which you want to create a connection during the installation. The default property is IS_SQLSERVER_DATABASE. If your project contains more than one SQL connection and you want to be able to use different properties for each connection, you can do so. For more information, see Specifying Whether New SQL Connections Should Share the Same Windows Installer Properties. |
|||||||||
|
Authentication Type Property Name |
Basic MSI, DIM, InstallScript MSI |
This setting enables you to select a property that identifies the type of authentication that you want to use to connect to the specified catalog. The default property is IS_SQLSERVER_AUTHENTICATION. The following numbers are valid property values:
If your project contains more than one SQL connection and you want to be able to use different properties for each connection, you can do so. For more information, see Specifying Whether New SQL Connections Should Share the Same Windows Installer Properties. |
|||||||||
|
Server Authentication Login ID Property Name |
Basic MSI, DIM, InstallScript MSI |
This setting enables you to select a property that identifies the login ID that should be used for server authentication. The default property is IS_SQLSERVER_USERNAME. If your project contains more than one SQL connection and you want to be able to use different properties for each connection, you can do so. For more information, see Specifying Whether New SQL Connections Should Share the Same Windows Installer Properties. |
|||||||||
|
Server Authentication Password Property Name |
Basic MSI, DIM, InstallScript MSI |
This setting enables you to select a property that identifies the password that should be used for server authentication. The default property is IS_SQLSERVER_PASSWORD. If your project contains more than one SQL connection and you want to be able to use different properties for each connection, you can do so. For more information, see Specifying Whether New SQL Connections Should Share the Same Windows Installer Properties. |
Project:If you change any of the SQL properties on the Advanced tab of a SQL connection in a Basic MSI project, the corresponding properties are not automatically updated in the SQLLogin dialog in the Dialogs view. Therefore, you must manually change the properties in the dialog to match the properties that selected on the Advanced tab of the SQL connection.
See Also