public inbox for [email protected]
help / color / mirror / Atom feedFrom: David Parenteau <[email protected]>
To: Pierre Couderc <[email protected]>
To: [email protected] <[email protected]>
Subject: RE: ODBC Driver for PostgreSQL
Date: Wed, 2 Nov 2022 12:42:32 +0000
Message-ID: <YT2PR01MB91929264769B486488F1F1ABC2399@YT2PR01MB9192.CANPRD01.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <[email protected]>
References: <5ORRUWQ68IU4.FI2XKUVP4AC32@rd00155d3b7f9f>
<PH0PR84MB157500369FE5B68D493604FA9E309@PH0PR84MB1575.NAMPRD84.PROD.OUTLOOK.COM>
<DB8PR01MB6106F0ED11A86C796418865BBD339@DB8PR01MB6106.eurprd01.prod.exchangelabs.com>
<PH0PR84MB1575296B6912D4B3017821E29E339@PH0PR84MB1575.NAMPRD84.PROD.OUTLOOK.COM>
<[email protected]>
<PH0PR84MB1575D8D185DCD6D2393F51C69E339@PH0PR84MB1575.NAMPRD84.PROD.OUTLOOK.COM>
<[email protected]>
<[email protected]>
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:[email protected]]
From: Pierre Couderc <[email protected]>
Sent: November 2, 2022 2:00 AM
To: [email protected]
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:[email protected]]
Thx,
Salvador T.
-----Original Message-----
From: Heikki Linnakangas <[email protected]><mailto:[email protected]>
Sent: Thursday, October 27, 2022 8:18 AM
To: [email protected]<mailto:[email protected]>; Torres Cervantes, Salvador <[email protected]><mailto:[email protected]>; [email protected]<mailto:[email protected]>
Subject: Re: ODBC Driver for PostgreSQL
CAUTION: External Email
On 27 October 2022 16:47:25 CEST, "Torres Cervantes, Salvador" <[email protected]<mailto:[email protected]>> 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.
Attachments:
[image/png] image001.png (52.6K, 3-image001.png)
download | view image
[image/png] image002.png (325.2K, 4-image002.png)
download | view image
view thread (12+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: RE: ODBC Driver for PostgreSQL
In-Reply-To: <YT2PR01MB91929264769B486488F1F1ABC2399@YT2PR01MB9192.CANPRD01.PROD.OUTLOOK.COM>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox