PostgreSQL ODBC Driver

Before you can connect to a PostgreSQL repository, you must first set up a PostgreSQL ODBC driver. To do this, you must have Microsoft MDAC components, a PostgreSQL DBMS system and a PostgreSQL ODBC driver (version 7.03.01.00 minimum) installed.

Note:

Do not use version 8.4.1 of the PostgreSQL ODBC Driver; it presents difficulties in transferring a project to a PostgreSQL repository.

To set up your PostgreSQL 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.
     
    ODBC_Add
     
  2. Click on the Add button. The Create New Data Source dialog displays, enabling you to add a new DSN.
     
    ODBC_NewDSN
     
  3. Select PostgreSQL UNICODE from the list.
  4. Click on the Finish button.
  5. Enter the following configuration details:
  • A name for the connection
  • The actual name of the database.
  • Description (optional)
  • The host address of the PostgreSQL server.
  • User name and password.

       PostgreODBCDriver
 

  1. Click on the Datasource button and set the options on Page 1 and Page 2 as shown on the examples below:
     
    PostgreAdvancedOptions
     
     
    PostgreAdvancedOptions2
     

Note:

On Page 2, For PostgreSQL version 8+ select the Disallow Premature checkbox and, in the Protocol panel, select the 7.4+ radio button.

  1. Click on the OK button to complete the configuration.

Your PostgreSQL ODBC driver is now available to use in creating a PostgreSQL repository and connecting to it in Enterprise Architect.