Re: Need help to choose which ODBC driver to use

Hi Adrian and All,

I just found my error on the new account. I am all set.

Thank you very much.

Pang

On Wed, May 24, 2017 at 11:39 AM, Pui Yin Pang <puiyin(dot)pang(at)boston(dot)gov>
wrote:

> I think so. I only has one Postgresql server.
>
> The other application I use to test the login is to create a new Access
> 2003 link table and I create a new ODBC connection and put in the same
> information as I did on the SQL server. It works.
>
> The different most likely is the the ODBC drive version installed on the
> desktop is different from the one I am trying to install on the SQL server.
> The desktop is 32bit Windows 7 and I installed the ODBC probably two years
> ago. I do not remember the version I installed, probably related to 9.4.
> The bin is in a ProgramFiles\psqlODBC\0900 folder.
>
> For the SQL server, I am get the driver from here:
> https://www.postgresql.org/ftp/odbc/versions/msi/
> psqlodbc_09_06_0310-x64.zip
>
> Thanks,
>
> Pang
>
> On Wed, May 24, 2017 at 10:39 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> > wrote:
>
>> 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
>>
>
>