Progress
Language Tutorial
for Windows
Connecting a Database
When you connect a database with the Data Dictionary, you make the database available to all Progress tools and applications. In other words, if you exit the Data Dictionary without explicitly disconnecting a connected database, the database is still available to other Progress tools and applications. From within the Data Dictionary, connecting a database also means that you have access to view or modify the database schema.
Follow these steps, to connect a database:
- In several cases, the Data Dictionary displays the Database Connect dialog box automatically. To access it directly, choose Database
Connect from the Data Dictionary main display. The dialog box appears, as shown below:
![]()
The Connect Database dialog box allows you to specify how you want to connect to a database. For specifics on database connection parameters, see the Progress Startup Command and Parameter Reference .
- Type sports in the Physical Name field.
The physical name is the name of the operating system file that contains the database. The physical name for the sports database is
sports.db
. You don’t need to type the .db extension because Progress looks for files with that extension.The logical name of a database is the database’s internal name. The default logical name is the same as the physical name. In this case, it’s sports. The logical name is the name you use to reference a database in a Progress procedure.
- Choose OK to connect to the new sports database and return to the Data Dictionary display. The Data Dictionary display confirms the database connection. The Databases selection list now lists the sports Database.
You can connect several databases, but you can only work with one at a time in the Data Dictionary. If you have several connected, choose the one you want to work with from the Databases selection list.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |