Kbase P147017: SQL: How to create the OpenEdge Driver using the DbVisualizer Driver Manager?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/28/2009 |
|
Status: Unverified
GOAL:
SQL: How to create the OpenEdge Driver using the DbVisualizer Driver Manager?
GOAL:
How to create an OpenEdge database connection using DbVisualizer?
GOAL:
How to connect to an OpenEdge database from the DbVisualizer?
FACT(s) (Environment):
Windows
OpenEdge 10.1x
OpenEdge 10.2x
FIX:
The following is a step by step procedure to create the OpenEdge Driver using the DbVisualizer Driver Manager, create a database connection using DbVisualizer and connect to an OpenEdge database from the DbVisualizer:
A. Create the OpenEdge Driver:
1. Double Click on your desktop DbVisualizer icon to start the application.
2. Click: Tools > Driver Manager from the main menu to access the Driver Manager Dialog.
3. Click: Driver > Create Driver from the main menu of the Driver Manager Dialog.
4. In the Driver Settings section enter the following information:
a. Name: OpenEdge
b. URL Format: <Driver Name>://<Host>:<Port>;databaseName=<Database Name>
5. In the 'Driver File Paths' section, select the 'User Specified' Tab.
6. Click the folder icon in the 'User Specified' Tab to access the windows file explorer 'Look in:' dialog.
7. Navigate to the DLC\java directory (for example: Progress\OpenEdge\java).
8. Select base.jar, openedge.jar, pool.jar, progress.jar, and util.jar and click Open.
9. Click Close to dismiss the Driver Manager Dialog.
B. Create Database Connection:
1. Click: Database > Create Database Connection from the main menu.
2. Click the ?No Wizard? button to access the Database Connection Dialog.
3. In the 'Connection' section of the Connection Tab, type or select the following information from the combo-box:
a. Alias: MyConnection
b. Database Type: Progress
c. Driver (JDBC): OpenEdge
d. Database URL: jdbc:datadirect:openedge://localhost:23456;databaseName=sports2000
4. In the 'Authentication' section of the Connection Tab, type the following information:
a. Userid: <Your User Id>
b. Password: <Your Password>
C. Connect to the database:
1. Click the Connect to to connect to the database:
2. The 'Connection Message' section should have display the connection details. For example if the database is an OpenEdge 10.1C03 database, the 'Connection Message' will display a message similar to the following:
OpenEdge RDBMS
10.1C03
OpenEdge
3.70.34 (029620.012906.004706)
If the database is an OpenEdge 10.2A01 database, the 'Connection Message' will a display a message similar to the following:
P>OpenEdge RDBMS
10.2A01
OpenEdge
3.70.34 (029620.012906.004706).