Re: ODBC Driver for PostgreSQL

On 11/2/22 06:51, Pierre Couderc wrote:
> 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(at)iki(dot)fi>
>> Sent: Thursday, October 27, 2022 8:18 AM
>> To: pgsql-odbc(at)lists(dot)postgresql(dot)org; Torres Cervantes, Salvador
>> <salvador(dot)torres(at)hp(dot)com>; 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
>>
> 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 !