From: | David Parenteau <dparenteau(at)axper(dot)com> |
---|---|
To: | Pierre Couderc <pierre(at)couderc(dot)eu>, "pgsql-odbc(at)lists(dot)postgresql(dot)org" <pgsql-odbc(at)lists(dot)postgresql(dot)org> |
Subject: | RE: ODBC Driver for PostgreSQL |
Date: | 2022-11-02 12:42:32 |
Message-ID: | YT2PR01MB91929264769B486488F1F1ABC2399@YT2PR01MB9192.CANPRD01.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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…
[cid:image001(dot)png(at)01D8EE97(dot)0B36C200]
From: Pierre Couderc <pierre(at)couderc(dot)eu>
Sent: November 2, 2022 2:00 AM
To: pgsql-odbc(at)lists(dot)postgresql(dot)org
Subject: 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
[cid:image002(dot)png(at)01D8EE97(dot)0B36C200]
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
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 !
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
From | Date | Subject | |
---|---|---|---|
Next Message | Pierre Couderc | 2022-11-02 14:33:20 | Re: ODBC Driver for PostgreSQL |
Previous Message | Pierre Couderc | 2022-11-02 05:59:49 | Re: ODBC Driver for PostgreSQL |