RE: ODBC Driver for PostgreSQL

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

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>; pgsql-odbc(at)lists(dot)postgresql(dot)org; 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

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" < <mailto:salvador(dot)torres(at)hp(dot)com> 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