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
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 |