Connection information dialog

The Connection information dialog gathers the details needed to connect to a database.

The Connection information dialog appears when you are creating or updating a meta-schema file, or when you are changing the connection for the DB Explorer plug-in.

Figure: Connection information dialog


Screen shot of the Connection information dialog.

The dialog can be seen as having four parts.

Schema details

The schema details section consists of two items. When not applicable, this section does not appear in the dialog.

Current schema
Identifies the current schema, if any. When you select to edit the database connection for a meta-schema file, the name of the currently connected database displays. If no connection has been made, the field states that no schema is selected.
Note: In some contexts, this read-only field does not display.
Keep schema connection information synchronized checkbox
When selected, the schema connection information will be permanently updated for the current meta-schema (.4db or .4dbx). This check box appears as selected and read-only when you edit the database connection for an existing meta-schema file. If you edit the connection from DB Explorer, you can uncheck this option to dissociate the DB Explorer connection information from the meta-schema connection information.
Note: In some contexts, this read-only field does not display.

Database Connection Information

In the Database Connection Information section, select either Use explicit settings or Use external settings.

Use explicit settings, previous connection
You can use a previous connection that was created for the same database. The drop down list provides a list of the existing connections.
Use explicit settings, database type
You can enter the Database Type by selecting the desired type from the drop down list, and the corresponding information for that type. The Database driver for the database type is automatically entered. If other drivers exist, they are available in the drop down list.
Use external settings
Information in the FGLPROFILE configuration file is used to extract the corresponding connection information for the specified database. Genero Studio will use the schema name that you entered to check for any related entry in the FGLPROFILE configuration file, and will use those values to define the connection. See information on the FGLPROFILE file in the Genero Business Development Language User Guide.

Database User Information

In the Database User Information section, provide the necessary database user details. The required information varies based on the database type selected. See Database server/user information.

Test Connection

Click Test Connection to verify that the information is correct and that you are able to access the database.