Enabling End Users to Specify Database Connection Information
InstallAnywhere 2024 R2
You can add to your projects run-time panels or consoles that enable end users to specify MySQL, Microsoft SQL Server, IBM DB2, and PostgreSQL database connection information such as the name of the server, as well as the credentials that should be used to connect to the server through server authentication. In addition, you can optionally enable end users to test the connection information that they entered.
Tip:Before you can add a database connection run-time panel or console to your project, you need to add a SQL database host. To learn more, see Adding a SQL Database Host to Your Project.
To add a Choose Database Connection run-time panel or console to your project:
| 1. | In the Advanced Designer, on the Sequence page, click Pre-Install. The Pre-Install view opens. |
| 2. | Click the Add Action button. The Choose an Action dialog box opens. |
| 3. | Do one of the following: |
| • | To add a Choose Database Connection panel: On the Panels tab, click the Panel: Choose Database Connection action, and then click the Add button. InstallAnywhere adds the action to the Pre-Install Action List. |
| • | To add a Choose Database Connection console: On the Consoles tab, click the Console: Choose Database Connection action, and then click the Add button. InstallAnywhere adds the action to the Pre-Install Action List. |
The Choose an Action dialog box remains open, enabling you to add additional actions as needed.
| 4. | Use the arrow keys to move the action up or down in the action list. The actions are listed in the order that they are run on target systems. |
| 5. | In the Properties Customizer area, configure each of the action’s settings as needed. |
For detailed information about each of the settings that you can configure for the actions, see the following:
| • | Choose Database Connection Panel Action |
| • | Choose Database Connection Console Action |
As an alternative to including a panel or console that enables end users to specify settings for database servers, you can add Set InstallAnywhere Variable actions to a sequence in your project to configure connection information. To learn more, see Setting Variables in the Advanced Designer.
To configure connection information for silent installers, you can use the user-defined SQL-related variables that are available in the Choose Database Connection actions or in the Run SQL Script action.
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.
See Also