RE: ODBC Driver for PostgreSQL

You have to take care to use “ODBC 32-bit” OR “ODBC 64-bit “ to create your ODBC. Systems allow you to create these 2 types. SQL Server probably use the 64bit but I would suggest to also test with a 32 bit ODBC…

On 10/27/22 17:51, Torres Cervantes, Salvador wrote:

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@iki.fi>
Sent: Thursday, October 27, 2022 8:18 AM
To: pgsql-odbc@lists.postgresql.org; Torres Cervantes, Salvador <salvador.torres@hp.com>; pgsql-odbc@postgresql.org
Subject: Re: ODBC Driver for PostgreSQL

 

CAUTION: External Email

 

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.

 

- Heikki

 

I do not know what you are trying to do with  SQL Server Management Studio (SSMS), but forget it ! This tool is only for MS products...

You cannot use it to test PostgreSQL...

Moreover, your connection is successful, I do not think you need anything more such as "creating the LINK Server on SQL"(???)....

Just start using it !