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.
Figure 6. Connect Database dialog box
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, specifies that a user wants to be prompted for a key store passphrase.
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 and if a match is found in the user list, it assigns the user ID to the new session. Otherwise, you will not be allowed you to connect to the database. For more information about user IDs and passwords, see OpenEdge Data Management: Database Administration.
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 OpenEdge Data Management: Database Administration and OpenEdge Deployment: Managing 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. See OpenEdge Getting Started: ABL Essentials for more information about the CONNECT statement. For more information about connection parameters, see OpenEdge Deployment: Startup Command and Parameter Reference.
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.