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.torres@hp.com] Sent: Thursday, October 27, 2022 11:51 AM To: Heikki Linnakangas <hlinnaka@iki.fi>; pgsql-odbc@lists.postgresql.org; pgsql-odbc@postgresql.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
On 27 October 2022 16:47:25 CEST, "Torres Cervantes, Salvador" <salvador.torres@hp.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.