Need help to choose which ODBC driver to use

From: Pui Yin Pang <puiyin(dot)pang(at)boston(dot)gov>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Need help to choose which ODBC driver to use
Date: 2017-05-24 14:07:48
Message-ID: CAOi5zHiQW4z9X=P1Dm1P9pRtL5T-hrvpbumbc-5zL=zkW4f7yg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

I am quite new to PostgreSQL and I need some help to choose the ODBC driver
to install on a new 64bit SQL server 2014 standard. It is on a Windows
Server 2012 R2 OS that is recently set up.

I need to set up a ODBC Data Sources and link server on the SQL server to
query data on a 64bit PostgreSQL 9.4.5 server. The PostgreSQL is on a 64bit
Windows Server 2008 R2 Enterprise OS.

I go to this link
https://www.postgresql.org/ftp/odbc/versions/msi/

and download psqlodbc_09_06_0310-x64.zip

and install it on the SQL server. Then I go to Server Manager >Tools>ODBC
Data Sources (64-bit) > System DSN

to create a new System Data Sources. When I click 'Test', it gives me an
error message:

Fatal:password authentication failed for user "dnddev"

I create this new user and I tested the connection on another application
so I know the password is correct.

Do I need to install an older version of ODBC driver on the SQL server? If
so, which one I should use? I try to find something like
psqlodbc_09_04_..... but I do not see one.

Thank you for the help.

Pang

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Adrian Klaver 2017-05-24 14:39:37 Re: Need help to choose which ODBC driver to use
Previous Message Hiroshi Saito 2017-05-11 15:23:15 psqlODBC 09.06.0310 Released