From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Pui Yin Pang <puiyin(dot)pang(at)boston(dot)gov>, pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Need help to choose which ODBC driver to use |
Date: | 2017-05-24 14:39:37 |
Message-ID: | 9981a396-b9db-0be8-f10b-9600f872105b@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
On 05/24/2017 07:07 AM, Pui Yin Pang wrote:
> 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.
Are you sure you are connecting to the same Postgres server in both cases?
>
> 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
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Pui Yin Pang | 2017-05-24 15:39:40 | Re: Need help to choose which ODBC driver to use |
Previous Message | Pui Yin Pang | 2017-05-24 14:07:48 | Need help to choose which ODBC driver to use |