Progress
Basic Database
Tools
Database>Connect
If Progress creates the database successfully, the Database Connect dialog box shown in Figure 8–5 appears.
Figure 8–5: Database Connect Dialog Box
![]()
This dialog box contains the following user-interface elements:
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 ismydb1
. For more information on logical database names, see the Progress Programming Handbook.Database Type
Specifies the database type. By default, the database type is Progress. The only possible value for this release is Progress.
Multiple Users
Specifies if you want multiple users to be able to 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, you must start a server for it using the PROSERVE utility.
NOTE: You must select this option if you are running a multi-user server and you want to connect to a self-service client.Userid
Identifies your user ID. Whether you enter a user ID and password depends on how you initially created the database. If you created a new database from the empty or sports database, then you don’t 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, for example, mydb, from a copy of another database that has a list of user IDs and passwords in the user list, then you must specify a valid user ID and password to connect to mydb.
Progress checks the entries, and if it finds a match for them in the user list, it assigns the user ID to the Progress session. Otherwise, Progress does not allow you to connect to mydb. For more information on user ID, and passwords, see the Progress Database Administration Guide and Reference.
Password
Identifies your password.
Trigger Location
Specifies the directory or Progress 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 to use when you run Progress with this database. For more information about parameter files, see the Progress Database Administration Guide and Reference and the Progress Client Deployment Guide.
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 Progress Data Dictionary. See the Progress Programming Handbook for more information about the CONNECT statement. For more information about connection parameters, see the Progress Startup Command and Parameter Reference.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |