PostgreSQL ODBC Driver

This topic explains how to set up a PostgreSQL ODBC driver.

Prerequisites:

You must first have installed:

Microsoft MDAC components
PostgreSQL DBMS and repository
PostgreSQL ODBC driver software version 7.03.01.00 or above (note that versions 8.3.4 and 8.4.1 of the PostgreSQL ODBC Driver are not supported)

Use to

Set up the PostgreSQL ODBC driver so that you can connect to your PostgreSQL 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 PostgreSQL UNICODE from the list.

 

4

Click on the Finish button.

The Postgre SQL Connector/ODBC dialog displays.

 

5

Enter the following configuration details:

A data source name for the connection
The actual name of the database
The host address of the DBMS server
User name
A description (optional)
The password

 

6

To set the advanced options, click on the Datasource button and set the options on Page 1 and Page 2 as shown below:

 

PostgreAdvancedOptions

 

 

PostgreAdvancedOptions2

 

7

If you are using PostgreSQL version 8+, on Page 2  select:

The Disallow Premature checkbox
In the Protocol panel, the 7.4+ radio button

 

8

Click on the OK button to complete the configuration.

 

Your PostgreSQL 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