Setting up PostgreSQL ODBC on Windows

Asked 22/7, 2011 at 21:18 Answered 8/12, 2014 at 9:43

Solved postgresql odbc database-connection driver

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.

Knockknee answered 22/7, 2011 at 21:18 Comment(0)

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

Marjorymarjy answered 23/7, 2011 at 6:20 Comment(2)

Thanks. I installed the 0310-x64 fine, but I still don't get PG in the ODBC control panel. Is something else needed besides simply running the MSI? – Knockknee 23/7, 2011 at 9:53

Installed it a second time, then is worked. Weird. Thanks much @Grzegorz! – Knockknee 23/7, 2011 at 10:3

Installing psqlODBC on 64bit Windows

Though you can install 32 bit ODBC drivers on Win X64 as usual, you can't configure 32-bit DSNs via ordinary control panel or ODBC datasource administrator.

How to configure 32 bit ODBC drivers on Win x64

Configure ODBC DSN from %SystemRoot%\syswow64\odbcad32.exe

Start > Run
Enter: %SystemRoot%\syswow64\odbcad32.exe
Hit return.
Open up ODBC and select under the System DSN tab.
Select PostgreSQL Unicode

You may have to play with it and try different scenarios, think outside-the-box, remember this is open source.

Faultfinder answered 4/4, 2013 at 19:59 Comment(3)

This worked for me! Note that after getting the 'connection successful' message on test I then got an architecture mismatch error. This was because the software modeler I was using was 32-bit and I had the 64-bit driver installed. I installed the 32-bit driver but had to follow the steps above to get it to show up in the configure tool since I had a 64-bit OS. Thanks again. – Counselor 22/9, 2014 at 14:19

Solved my problem too!! =)))))) Thaks brow xD – Crista 31/1, 2020 at 2:0

I am using 64-bit machine (and Visio 64-bit) but psqlODBC 64-bit is not showing at step (2). Maybe because it is odbcad32.exe. Either way, successfully works when I am using psqlODBC 32 bit installer. – Olivarez 15/7, 2020 at 5:30

Please note that you must install the driver for the version of your software client(MS access) not the version of the OS. that's mean that if your MS Access is a 32-bits version,you must install a 32-bit odbc driver. regards

Umbrageous answered 22/8, 2012 at 11:26 Comment(1)

also note that C:\Windows\System32\odbcad32.exe manages your 64-bit ODBC drivers and DSNs, and C:\Windows\SysWOW64\odbcad32.exe manages your 32-bit ODBC drivers and DSNs – Piezoelectricity 8/1, 2013 at 22:32

First you download ODBC driver psqlodbc_09_01_0200-x64.zip then you installed it.After that go to START->Program->Administrative tools then you select Data Source ODBC then you double click on the same after that you select PostgreSQL 30 then you select configure then you provide proper details such as db name user Id host name password of the same database in this way you will configured your DSN connection.After That you will check SSL should be allow .

Then you go on next tab system DSN then you select ADD tabthen select postgreSQL_ANSI_64X ODBC after you that you have created PostgreSQL ODBC connection.

Alyse answered 8/12, 2014 at 9:43 Comment(0)

Recommended topics

Hot tags