Introduction

The psqlODBC Drivers for Windows are not distributed pre-built for 64-bit Windows. So we had to build them ourselves.

If you're trying to use PostgreSQL with ODBC on 64-bit Windows, this is what you need to install. (Download)

Details

The installer includes the required OpenSSL binaries as well.
This version of psqlODBC is built with LibPQ statically linked in.

Comment by jerr...@gmail.com, Oct 27, 2009

You are a gentleman (or woman) and a scholar. Many thanks for making this build available. You saved me a lot of hassle.

Jerry from STL

Comment by fburz...@gmx.de, Mar 8, 2010

I stared to install ODBC Driver for Windows 7 (64Bit) from the msi-Distribution. When started do configure ODBC-Driver as Datasource i did not find them shown in the list. --> Solution from web-search ...

There are two copies of odbcad32.exe on Windows Vista x64, one is stored at c:\windows\system32\ and one is stored at c:\windows\syswow64\. You need to run c:\windows\syswow64\odbcad32.exe to have access for all other ODBC drivers.

This works as expected for me .... no special software needed !!!

Comment by cdclem...@gmail.com, Mar 31, 2010

I am unable to use SSL Mode "required". I get the error "Sslmode value "require" invalid when SSL Support is not compiled in", even after installing OpenSSL libraries for Windows separately. Any ideas?

Comment by todosoft...@gmail.com, Apr 23, 2010

Trabajo con visual foxpro 9.0, con las versiones anteriores para xp el ODBC funciona bien, instale ODBC a 64 version 8.03.04 y todo bien, pero llamo la conexion Conect=(PostgrSQL 64-Bit ODBC Drives);Port=5432;Database="colegios";usuario="postgres";clave="postgres"

desde mi aplicacion y nada de nada

Agradezco quien me da una idea

Saludos

Alqui

Comment by project member assafla...@gmail.com, Apr 27, 2010

Please do not post bug reports/requests here in comments. There's an issue tracking system for that: http://code.google.com/p/visionmap/issues/list

Comment by michael....@gmail.com, Apr 28, 2010

Thanks for making this available. I have an Excel spreadsheet that connects to postgresql which I couldn't update since upgrading to 64 bit Excel 2010. This driver solves the issue.

SSL does not seem to be supported. I've worked around this issue by creating an ssh tunnel using putty and allowed unencrypted connections from the local host.

Comment by yodan.ta...@gmail.com, Jun 6, 2010

Please note that this release seems to use a different driver name than the official (32-bit only) release.

This means you need to use "Driver={PostgreSQL 64-Bit ODBC Drivers}" in your connection string instead of "Driver={PostgreSQL}".

Comment by simeo.r...@gmail.com, Jun 15, 2010

many many thanks for ur work man! Our best regards

Comment by brofi...@gmail.com, Jun 22, 2010

Are these drivers Unicode or ANSI?

Comment by AnthonyJ...@gmail.com, Nov 1, 2010

You are a legend! Great work fella!

Comment by telmofdu...@gmail.com, Feb 3, 2011

Looks like this is ANSI. Is there a Unicode version?

Comment by mahel...@gmail.com, Feb 10, 2011

can some one help me... i install this driver in windows 7 64 bits... the test in the odbc list it´s ok, but when i use excel 2010 to conect to postgres... i have this error "DSN specified architecture mismatch between the controller and the application"

how can i get information from postgres to excel with this driver?????

Comment by cheeta...@gmail.com, Mar 29, 2011

THANK YOU! THANK YOU! THANK YOU! THANK YOU! THANK YOU! I've been fighting with this all day and am about bald. This worked like a champ.

Comment by herson.g...@gmail.com, Oct 11, 2011

THANK YOU! THANK YOU! THANK YOU! THANK YOU! THANK YOU!

Comment by vla...@gmail.com, Feb 3, 2012

thank fburz...@gmx.de your suggestion worked to me

► Sign in to add a comment