Change connection details

In order to show or edit data, you must be connected to a relational database.

1. Open the Connection information dialog.
   • From within DB Explorer view, click the Choose Connection Information icon.
   • With the meta-schema file (.4db, .4dbx) opened in the central work area, select Database > Edit Database Connection.
   • With the meta-schema file (.4db, .4dbx) opened in the central work area, click anywhere within the white space in the meta-schema diagram and select Edit Database Connection from the context menu.
   • With the meta-schema file (.4db, .4dbx) opened in the central work area, in the Database Structure view, right-click on the database node and select Edit Database Connection.
2. On the Connection information page, complete the three areas.
   1. Check (or de-select) the Keep schema connection information synchronized check box.
      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.
   2. 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.

   3. In the Database User Information section, provide the necessary database user details. The required information varies based on the database type selected. See Provide database connection and user information.
3. Click Test Connection to verify your configuration.
4. Click OK to close the dialog.