Set up a Progress OpenEdge ODBC Driver

Return to Introduction  Previous page  Next page

Before you can connect to an OpenEdge data repository, you must first set up an OpenEdge ODBC driver. To do this, you must have Microsoft MDAC components, OpenEdge DBMS system and DataDirect ODBC driver for OpenEdge (version 4.20 minimum) installed.

To set up the ODBC Driver, follow the steps below:

1.Select the WindowsTM Control Panel | Administrative Tools | Data Sources (ODBC) option. The ODBC Data Sources Administrator window displays.
2.Click on the Add button. The Create New Data Source dialog displays, enabling you to add a new DSN.
3.Select  the DataDirect/OpenEdge SQL driver from the list.
4.Click on the Finish button. The DSN Configuration dialog displays.
5.Enter the following configuration details:
·The Data Source Name
·The Description (optional)
·The Host Name and Port Number of the DBMS server
·The Database Name on the selected server
·The User ID.

See the example below:

6.Click on the Test Connect button to confirm that the details are correct.
7.If the test succeeds, click on the OK button to complete the configuration.
8.If the test does not succeed, review your settings.

Your OpenEdge connection is now available to use in Enterprise Architect.