Use the Database > Connect menu option to connect to an existing database. After you choose the Connect option, the Connect Database dialog box, as shown in the following figure, appears. Note that the ConnectDatabase dialog box also appears after you create a database using the Database > Create menu option.

The Connect Database dialog box contains the following fields:

  • Physical Name — Specifies the actual name of the database on a disk. This name can contain an explicit path or it can be relative to your propath.
  • Logical Name — Specifies the database name that references a connected physical database. For example, if the physical database name is mydb1.db, the default logical database name is mydb1.
  • Database Type — Specifies the database type. By default, the database type is PROGRESS.
  • Multiple Users — Specifies if multiple users can access this database at the same time. The default is single-user. An x indicates multiple users can access the database. Before you can connect to a multi-user database, a server must be started for it using the PROSERVE command.
Note: You must select this option if you are running a multi-user server and you want to connect to a self-service client.
  • Passphrase — For databases enabled for transparent data encryption (TDE), specifies that a user wants to be prompted for a key store passphrase.
  • Pin — For databases enabled for transparent data encryption (TDE) and using an HSM to access its keystore, select the PIN (Personal Identification Number) to specify the HSM user account password to use in HSM authentication prior to the TDE keystore authentication. If you select Pin, a pop-up prompts you to enter the PIN. If you select both Pin and Passphrase, a single pop-up prompts you for both.
  • User ID — Identifies your user ID. Whether you enter a user ID and password depends on how your security is configured. If you created a new database from an empty database or the SPORTS database, you do not have to enter any values for user ID or password because, by default, the security for these databases is not enabled. However, if you created a database from a copy of another database that has a list of user IDs and passwords in the user list, you must specify a valid user ID and password.

    The Data Dictionary searches for the entered identification and passwords in the user list, and if it finds a match, it assigns the user ID to the new session. Otherwise, you will not be allowed to connect to the database. For more information about user IDs and passwords, see Manage the OpenEdge Database.

  • Password —Identifies your password.
  • Trigger Location — Specifies the directory or r-code library containing the trigger code for the database.
  • Parameter File — Specifies the parameter filename that contains the startup parameters for the database. The parameter file can include any number of startup parameters. For more information about parameter files, see Manage the OpenEdge Database and Manage ABL Applications.
  • Other CONNECT Statement Parameters — Specifies any other startup parameters for the database that are not included in the parameter file. For example, enter any parameters you want to use that are not defined by this dialog box (or by the parameter file, if you included one in the Parameter File area).

    Internally, the Data Dictionary constructs and executes a CONNECT statement using the information you supply. Therefore, any rules that apply to the CONNECT statement also apply to database connections using the Data Dictionary. For more information about the CONNECT statement, ee Develop ABL Applications. For more information about connection parameters, see Startup Command and Parameter Reference.