PostgreSQL ODBC Setup
How to set up a new ODBC data source for PostgreSQL on Windows:
STEP 1: Install the latest PostgreSQL ODBC drivers
-
Download the latest 64 bit driver installer (zipped msi file) from the psqlodbc download site.
-
Unzip the file, run the msi installer and accept the defaults.
Iguana may not always support the very latest version of ODBC drivers, so you can simply download an earlier version if necessary.
If you need to know which versions are supported by the version of Iguana you are using please contact us at support@interfaceware.com.
STEP 2: Use the 64 bit ODBC Administrator to create the ODBC data source
-
On your Windows machine, search “ODBC” to find ODBC Data Sources (64 bit). Right Click and choose Run as Administrator to open the ODBC Data Source Administrator.
-
Open the System DSN tab and click Add.
-
Choose the latest PostgreSQL ODBC driver and click Finish.
-
Enter the ODBC credentials:
-
Use any Data Source and Description you prefer.
-
Enter the Network Name of the PostgreSQL Server in the Server field.
-
Enter the User name and Password.
-
Optional: Choose your default Database.
-
Optional: Enter the Port number (default = 5432).
-
Before creating the data source, click Test to test the connection with your database.
You should receive a Connection Successful test result. If unsuccessful, speak to your DBA (database administrator) and try the tips below.
STEP 3: If your connection is unsuccessful, talk to your DBA and try these troubleshooting tips
There are a few settings that you may need to change:
-
User Authentication: Talk to your DBA to get the correct credentials to connect to a PostregSQL database.
-
Database: You can specify the database that you want to use by default - you may be testing the wrong database connection.
-
Incorrect port number: PostgreSQL defaults to port 5432, but a different port can be used. Speak to your database administrator (DBA) or network administrator.
STEP 4: Confirm IguanaX has detected the ODBC library in Settings > Database
In IguanaX, Settings > Database confirm the ODBC library has been detected and loaded correctly.
If not, click Edit to manually add the ODBC shared library path. If you don't know the location, you can search for the odbc32.dll