Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.

Progress OpenEdge ODBC Driver

This topic explains how to set up a Progress OpenEdge ODBC driver.

Prerequisites:

You must first have installed:

  • Microsoft MDAC components
  • OpenEdge DBMS and repository
  • DataDirect ODBC driver for OpenEdge software (version 4.20 minimum)

Use to:

  • Set up the Progress OpenEdge ODBC driver so that you can connect to your OpenEdge repository in Enterprise Architect

How to:

Step

Action

1

Select the WindowsTM Control Panel | Administrative Tools | Data Sources (ODBC) option

The ODBC Data Source 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 DataDirect/OpenEdge SQL Driver from the list

4

Click on the Finish button

The DSN Configuration dialog displays

5

Enter the following configuration details:

  • A data source name for the connection
  • A description (optional)
  • The host name and port number of the DBMS server
  • The database name on the selected server
  • The User ID

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
  • If the test does not succeed, review your settings

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

Notes:

  • Enterprise Architect requires 32-bit ODBC drivers to connect to a repository through ODBC; to set up the ODBC configuration on 64-bit clients, run the 32-bit ODBC Data Source Administrator from C:\Windows\SysWOW64\odbcad32.exe

Learn More: