Setting up PostgreSQL ODBC on Windows

postgresql odbc database-connection driver
IamIC picture IamIC · Jul 22, 2011 · Viewed 128.8k times · Source

I have the latest 64 bit version of PostgreSQL. I am running Win 7 64 bit. I had installed the ODBC driver (via the initial installer) when I installed PG, and upgraded it to the latest version from http://www.postgresql.org/ftp/odbc/versions/msi/.

However, when I go to the ODBC control panel and try to add a User DSN, PostgreSQL isn't listed as a server.

I was following the instructions given here, but I noted the links are dated.

Answer

Grzegorz Szpetkowski picture Grzegorz Szpetkowski · Jul 23, 2011

As I see PostgreSQL installer doesn't include 64 bit version of ODBC driver, which is necessary in your case. Download psqlodbc_09_00_0310-x64.zip and install it instead. I checked that on Win 7 64 bit and PostgreSQL 9.0.4 64 bit and it looks ok:

enter image description here

Test connection:

enter image description here

Related questions

How do I change a Crystal Report's ODBC database connection at runtime?

I have a report made with Crystal Reports 2008 that I need to deploy a production system which means that I need to be able to change the database connection at runtime. The database is PostgreSQL 8.3.0 and the connection I use …

Read More
Connecting Excel to PostgreSQL via VBA

Is it possible to make query like SELECT from VBA in Excel, so I can query a PostgreSQL DB from Excel? If is possible please explain me how to connect to the database. I was looking in Google but found …

Read More
PostgreSQL ODBC driver not showing up in Control Panel (Data Sources)

I installed psqlODBC and when I go to Control Panel -> Data Sources (ODBC) I don't see the Postgres driver installed. I rebooted, still nothing. I then noticed that if I launch this control panel applet from the file …

Read More