How To Install Postgresql Odbc Driver On Windows

Connect to PostgreSQL from Windows with ODBC

Introduction
Connect to PostgreSQL Server
Setup ODBC
Troubleshooting
More Information

Introduction

This commodity explains how to connect to PostgreSQL with the official PostgreSQL ODBC driver psqlodbc, when using Windows x.

It covers the following topics:

How to connect to postrgreSQL (with code samples).
How to setup ODBC:
- Configure ODBC using the ODBC Data Source Administrator:
  We recommend using organisation DSNs (available to all users).

Connect to PostgreSQL Server [top]

We strongly recommend using connection objects to connect to databases, and this is what we demonstrate in the code samples.

Follow these steps to connect:

Create a new aqueduct to try out the lawmaking:
- Create a channel like this:
  - Name: DB PostgreSQL Connexion (or similar)
  - Source: From Translator
  - Destination: To Channel
- Alternatively use an existing channel:
  Your channel volition need a From/To Translator or a Filter component.
Connect to a database using ODBC:
- Paste this code into the Translator:
  If your script uses connectedness object methods conn:query{} or conn:execute{}to connect to a remote PostgreSQL database, the location of the remote host is specified as part of the name parameter in the db.connect{ } control. If you utilise conn:merge{} to connect the remote host is specified as part of the name parameter in the conn:merge{} control itself.
```
part primary()       local conn = db.connect{          api=db.POSTGRES,       name='your_odbc_server_name',       user='your_login',       password='secret',       use_unicode = truthful,       alive = true    }     conn:execute{sql='SELECT * FROM <your tabular array>', live=true} end
```
- The name is the name of an ODBC source that you create using the ODBC Ambassador.
Adapt the code to your requirements.

Setup ODBC [peak]

Note: Iguana may not e'er support the very latest version of the PostgreSQL ODBC drivers, so yous tin can merely download an before version if necessary. This is especially true if you are not able to use the the latest version of Iguana.

If you demand to know which versions of PostgreSQL are supported by the version of Iguana you are using please contact united states of america at support@interfaceware.com.

To set up up a new ODBC data source for PostgreSQL:

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 have the defaults.
Open up the 64 bit ODBC Ambassador:
Windows 10 (64 bit version) supports 32 and 64 bit ODBC sources — always utilise the 64 bit ODBC Administrator.
Open the System DSN tab and click Add together:
Choose the latest PostgreSQL ODBC driver and click Finish:
Enter the ODBC credentials:
- Utilise whatever Information Source and Description you prefer.
- Optional: Choose your default Database.
- Enter the Network Proper noun of the PostgreSQL Server in the Server field:
  Note: If you are unsure of the name ask your DBA (database administrator).
- Optional: Enter the Port number (default = 5432)
- Enter the User proper name and Password:
  Note: If y'all are unsure of these ask your DBA (database ambassador).
Test the information source connexion:
If the connection does not work speak to your DBA (database ambassador) about how to login to the database (user authentication).

Troubleshooting [top]

Problems with connectedness settings:
Speak to your DBA (database administrator) for general connectedness bug like: User name and countersign, Database Server network name etc.
Iguana may non always back up the very latest version of the psqlodbc ODBC drivers:
Please contact us at support@interfaceware.com if you need to know the latest supported version of the psqlodbc ODBC drivers.
Incorrect port number:
SQL Server defaults to port 5432, but a dissimilar port can be used. Speak to your database administrator (DBA) or network administrator.
Using integrated security:
Using integrated security is the usual fashion to connect to a Microsoft SQL Server database. If this does non work speak to your DBA (database administrator).