RE: ODBC Driver for PostgreSQL

Hi Regina,
I have created under System DSN. Let me test again.

Thx,
Salvador T.

From: Regina Obe <lr(at)pcorp(dot)us>
Sent: Tuesday, November 1, 2022 9:27 AM
To: Torres Cervantes, Salvador <salvador(dot)torres(at)hp(dot)com>; 'Heikki Linnakangas' <hlinnaka(at)iki(dot)fi>; pgsql-odbc(at)lists(dot)postgresql(dot)org; pgsql-odbc(at)postgresql(dot)org
Subject: RE: ODBC Driver for PostgreSQL

CAUTION: External Email
I can’t tell from your screenshot if you have registered a file dsn, user dsn, or system dsn.
To work in SQL Server, I think it has to be a System DSN. Also make sure you are using the 64-bit ODBC Manager and not the 32-bit one. Note the top of the dialog should say “64-bit” and your entry should be in the System DSN section

[cid:image001(dot)png(at)01D8EF72(dot)F0F18560]

From: Torres Cervantes, Salvador [mailto:salvador(dot)torres(at)hp(dot)com]
Sent: Thursday, October 27, 2022 11:51 AM
To: Heikki Linnakangas <hlinnaka(at)iki(dot)fi<mailto:hlinnaka(at)iki(dot)fi>>; pgsql-odbc(at)lists(dot)postgresql(dot)org<mailto:pgsql-odbc(at)lists(dot)postgresql(dot)org>; pgsql-odbc(at)postgresql(dot)org<mailto:pgsql-odbc(at)postgresql(dot)org>
Subject: RE: ODBC Driver for PostgreSQL

OK.

I was able to install new Driver and Connection Successful but still have an error when creating the LINK Server on SQL

[cid:image002(dot)jpg(at)01D8EF72(dot)F0F18560]

Thx,

Salvador T.

-----Original Message-----
From: Heikki Linnakangas <hlinnaka(at)iki(dot)fi<mailto:hlinnaka(at)iki(dot)fi>>
Sent: Thursday, October 27, 2022 8:18 AM
To: pgsql-odbc(at)lists(dot)postgresql(dot)org<mailto:pgsql-odbc(at)lists(dot)postgresql(dot)org>; Torres Cervantes, Salvador <salvador(dot)torres(at)hp(dot)com<mailto:salvador(dot)torres(at)hp(dot)com>>; pgsql-odbc(at)postgresql(dot)org<mailto:pgsql-odbc(at)postgresql(dot)org>
Subject: Re: ODBC Driver for PostgreSQL

CAUTION: External Email

On 27 October 2022 16:47:25 CEST, "Torres Cervantes, Salvador" <salvador(dot)torres(at)hp(dot)com<mailto:salvador(dot)torres(at)hp(dot)com>> wrote:

>Hello,

>I'm trying to use your drivers. But I have the following error message. Could you please help ? any idea why ?

"authentication method 10 not supported" means that the server is configured to use SCRAM authentication, and the driver is an old version that doesn't support it. Upgrade the ODBC driver.

- Heikki