Kbase P106427: How to connect a Progress Database using the DB Navigator in OpenEdge Architect ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
How to connect a Progress Database using the DB Navigator?
GOAL:
How to use the DB Navigator with Progress OpenEdge 10.1A?
GOAL:
How to run simple SQL queries against a Progress database?
GOAL:
What tools are available to connect to a Progress database using SQL?
FACT(s) (Environment):
OpenEdge 10.1x
FIX:
The DB Navigator perspective in OpenEdge Architect provides a graphical user interface to view a Progress database and run SQL queries.
OpenEdge Architect was introduced in OpenEdge 10.1A. Follow the following steps to perform a connection to a Progress Database from the new DB Navigator:1. Create a Connection Profile
- From the Workbench select the menu option for Window > Preferences.
- In the Preferences dialog, select (OpenEdge) DB Navigator > Connection Profiles.
- Press the Add button. The "Create New Alias!" dialog is displayed.
- Enter a unique name for the connection profile.
- Select the Progress OpenEdge Release 10 Driver, if it is not already selected.
- Select the "Host Details" radio button.
- Enter the Hostname, Port and Database Name.
- Optionally you can type the User Name and Password or leave them blank.
- You may also want to select the checkbox at the end to reconnect this datasource every time the OpenEdge Architect is used.
- Press OK to create the connection profile to return to the Preferences dialog. Notice that the new connection profile is now listed in the Connections Profiles.
- Within the Connection Profiles window, double click the Alias of the connection, this will launch the Connection dialog.
- Enter the user name, and if you have a password then enter the password. By default there is no password.
- Press OK.
- If no error is returned this indicates that all the parameters are correct and that the datasource can be used to check the schema or browse through the database contents.
NOTE:
The DB Navigator is based on SQL-92. This means that the user who created the database is the default SQL-92 DBA. Users, without DBA privileges, have the ability to view the meta-schema. They do not have the ability to preview or update data. Users defined with DBA privileges have the ability to access, modify, and delete database objects. Please refer to Solution 20143, "Basic Guide to Defining Progress SQL-92 Database Permissions & Security" for further details.
2 . Connect to the database using the connection profile
- Go to the OpenEdge Architect workbench.
- Change to the DB Navigator perspective by selecting Window > Open Perspective > Other.
- Select the DB Navigator perspective from the list.
- Press the OK button. The Workbench is arranged to show the layout and views for the DB Navigator perspective.
- The Connections view is in the lower left of the Workbench.
OpenEdge 10.1A:
- Double-click on newly created datasource in the Connections view.
- Enter the user name, and if you have a password then enter the password. By default there is no password.
- Press OK to make the connection to the database.