Thread: ODBC Driver for PostgreSQL
Hello,
I’m trying to use your drivers. But I have the following error message. Could you please help ? any idea why ?
Regards,
Salvador T.
Attachment
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 driveris an old version that doesn't support it. Upgrade the ODBC driver. - Heikki
Which driver do you recommend to use ?
This is the one I'm using.
Thx,
-----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
Attachment
Is Version 13 ok ?
From: Torres Cervantes, Salvador
Sent: Thursday, October 27, 2022 8:25 AM
To: Heikki Linnakangas <hlinnaka@iki.fi>; pgsql-odbc@lists.postgresql.org; pgsql-odbc@postgresql.org
Subject: RE: ODBC Driver for PostgreSQL
Which driver do you recommend to use ?
This is the one I'm using.
Thx,
-----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
Attachment
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
Attachment
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
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
Attachment
@font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;}p.MsoPlainText, li.MsoPlainText, div.MsoPlainText {mso-style-priority:99; mso-style-link:"Plain Text Char"; margin:0cm; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;}span.PlainTextChar {mso-style-name:"Plain Text Char"; mso-style-priority:99; mso-style-link:"Plain Text"; font-family:"Calibri",sans-serif;}.MsoChpDefault {mso-style-type:export-only; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;}div.WordSection1 {page:WordSection1;} 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...
Attachment
On 10/27/22 17:51, Torres Cervantes, Salvador wrote:@font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;}p.MsoPlainText, li.MsoPlainText, div.MsoPlainText {mso-style-priority:99; mso-style-link:"Plain Text Char"; margin:0cm; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;}span.PlainTextChar {mso-style-name:"Plain Text Char"; mso-style-priority:99; mso-style-link:"Plain Text"; font-family:"Calibri",sans-serif;}.MsoChpDefault {mso-style-type:export-only; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;}div.WordSection1 {page:WordSection1;} 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 !
Attachment
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…
From: Pierre Couderc <pierre@couderc.eu>
Sent: November 2, 2022 2:00 AM
To: pgsql-odbc@lists.postgresql.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
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 !
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.
Attachment
@font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0cm; font-size:11.0pt; font-family:"Calibri",sans-serif;}a:link, span.MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline;}p.MsoPlainText, li.MsoPlainText, div.MsoPlainText {mso-style-priority:99; mso-style-link:"Plain Text Char"; margin:0cm; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;}span.PlainTextChar {mso-style-name:"Plain Text Char"; mso-style-priority:99; mso-style-link:"Plain Text"; font-family:"Calibri",sans-serif;}span.EmailStyle21 {mso-style-type:personal-reply; font-family:"Calibri",sans-serif; color:windowtext;}.MsoChpDefault {mso-style-type:export-only; font-size:10.0pt;}div.WordSection1 {page:WordSection1;} 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…
Mmm, the point is not "SQL server"... Certainly, there is no "SQL Server" at all !!!.
The point is 32bits application or 64bits application...
I meant, when you create your Linked Server and specify the ODBC Name you just created, maybe you should specify a 64-bit ODBC name… But if you created yours using the 32-bit application, then it’s normal that process cannot find it. Make sure you have a 32bit and a 64bit ODBC so this way, you make sure ODBC exists under both versions.
HTH.
From: Pierre Couderc <pierre@couderc.eu>
Sent: November 2, 2022 10:33 AM
To: pgsql-odbc@lists.postgresql.org
Subject: Re: ODBC Driver for PostgreSQL
On 11/2/22 13:42, David Parenteau wrote:
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…
Mmm, the point is not "SQL server"... Certainly, there is no "SQL Server" at all !!!.
The point is 32bits application or 64bits application...
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.
Hi Regina,
I have created under System DSN. Let me test again.
Thx,
Salvador T.
From: Regina Obe <lr@pcorp.us>
Sent: Tuesday, November 1, 2022 9:27 AM
To: Torres Cervantes, Salvador <salvador.torres@hp.com>; 'Heikki Linnakangas' <hlinnaka@iki.fi>; pgsql-odbc@lists.postgresql.org; pgsql-odbc@postgresql.org
Subject: RE: ODBC Driver for PostgreSQL
CAUTION: External Email
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
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