Choose Database Connection Panel Action
InstallAnywhere 2021
The Choose Database Connection panel action enables end users to specify information for connecting to a MySQL, Microsoft SQL Server, or PostgreSQL database. The variables that are used to store the values that end users specify can be used with the Run SQL Script action to run a SQL script.
Important:SQL databases limit remote administration by users unless otherwise configured. Therefore, for connections to remote SQL database servers, the user name and the password that the end user specifies must be for a user who is running the installer from an appropriate IP address and has been granted adequate privileges that are required to run your SQL script.
The Choose Database Connection customizer includes the following tabs:
| • | General Settings |
| • | Image Settings, Label Settings, and Help Settings |
The General Settings tab of the Choose Database Connection customizer includes the following settings:
|
Setting |
Description |
|
Title |
Enter the text that you want to use in the title bar of the panel. The default value is: Choose Database Connection |
|
Instructions |
Enter the text that you want to display on the Choose Database Connection panel. The default value is: Provide database configuration details and authentication |
|
Database Name |
Specify the name of the database on which the installer is running the SQL script. By default, the entry in this setting is the user-defined variable $DB_NAME_VARIABLE$. You can specify a different variable if needed. |
|
Server Host |
Specify the server host to which your installer is connecting. By default, the entry in this setting is the user-defined variable $DB_SERVERHOST_VARIABLE$. You can specify a different variable if needed. |
|
Server Port |
Specify the port that should be used for the server connection. By default, the entry in this setting is the user-defined variable $DB_SERVERPORT_VARIABLE$. You can specify a different variable if needed. |
|
User Name |
Specify the user name for the account that should be used to connect to the server through server authentication. By default, the entry in this setting is the user-defined variable $DB_USERNAME_VARIABLE$. You can specify a different variable if needed. |
|
Password |
Specify the password that corresponds with the specified user name for the account that should be used to connect to the server through server authentication. By default, the entry in this setting is the user-defined variable $DB_PASSWORD_VARIABLE$. You can specify a different variable if needed. |
|
Include Test Connection button on run-time panel |
If you want the Choose Database Connection panel to include a Test Connection button that lets end users test the connection information that they entered, select this check box. |
|
Enable test connection when the Next button is clicked |
If you want the clicking of the Next button on the Choose Database Connection panel to test the connection information that end users entered, select this check box. |
|
Test Connection Type |
Select the type of database to which your installer is connecting. |
Image Settings, Label Settings, and Help Settings
For information on using the options on the Image Settings, Label Settings, and Help Settings tabs, see Panel Action Settings.
See Also
Choose Database Connection Console Action
Enabling End Users to Specify Database Connection Information