public inbox for [email protected]help / color / mirror / Atom feed
ODBC Driver for PostgreSQL 12+ messages / 5 participants [nested] [flat]
* ODBC Driver for PostgreSQL @ 2022-10-27 14:47 Torres Cervantes, Salvador <[email protected]> 0 siblings, 1 reply; 12+ messages in thread From: Torres Cervantes, Salvador @ 2022-10-27 14:47 UTC (permalink / raw) To: pgsql-odbc Hello, I'm trying to use your drivers. But I have the following error message. Could you please help ? any idea why ? [cid:[email protected]] Regards, Salvador T. Attachments: [image/png] image001.png (88.4K, 3-image001.png) download | view image ^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: ODBC Driver for PostgreSQL @ 2022-10-27 15:18 Heikki Linnakangas <[email protected]> parent: Torres Cervantes, Salvador <[email protected]> 0 siblings, 2 replies; 12+ messages in thread From: Heikki Linnakangas @ 2022-10-27 15:18 UTC (permalink / raw) To: [email protected]; Torres Cervantes, Salvador <[email protected]>; pgsql-odbc On 27 October 2022 16:47:25 CEST, "Torres Cervantes, Salvador" <[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 ^ permalink raw reply [nested|flat] 12+ messages in thread
* RE: ODBC Driver for PostgreSQL @ 2022-10-27 15:25 Torres Cervantes, Salvador <[email protected]> parent: Heikki Linnakangas <[email protected]> 1 sibling, 1 reply; 12+ messages in thread From: Torres Cervantes, Salvador @ 2022-10-27 15:25 UTC (permalink / raw) To: Heikki Linnakangas <[email protected]>; [email protected] <[email protected]>; pgsql-odbc Which driver do you recommend to use ? This is the one I'm using. [cid:[email protected]] Thx, -----Original Message----- From: Heikki Linnakangas <[email protected]> Sent: Thursday, October 27, 2022 8:18 AM To: [email protected]; Torres Cervantes, Salvador <[email protected]>; [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 Attachments: [image/png] image001.png (3.7K, 3-image001.png) download | view image ^ permalink raw reply [nested|flat] 12+ messages in thread
* RE: ODBC Driver for PostgreSQL @ 2022-10-27 15:28 Torres Cervantes, Salvador <[email protected]> parent: Torres Cervantes, Salvador <[email protected]> 0 siblings, 0 replies; 12+ messages in thread From: Torres Cervantes, Salvador @ 2022-10-27 15:28 UTC (permalink / raw) To: Heikki Linnakangas <[email protected]>; [email protected] <[email protected]>; pgsql-odbc Is Version 13 ok ? [cid:[email protected]] From: Torres Cervantes, Salvador Sent: Thursday, October 27, 2022 8:25 AM To: Heikki Linnakangas <[email protected]>; [email protected]; [email protected] Subject: RE: ODBC Driver for PostgreSQL Which driver do you recommend to use ? This is the one I'm using. [cid:[email protected]] Thx, -----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 Attachments: [image/png] image002.png (231.2K, 3-image002.png) download | view image [image/png] image003.png (3.7K, 4-image003.png) download | view image ^ permalink raw reply [nested|flat] 12+ messages in thread
* RE: ODBC Driver for PostgreSQL @ 2022-10-27 15:51 Torres Cervantes, Salvador <[email protected]> parent: Heikki Linnakangas <[email protected]> 1 sibling, 2 replies; 12+ messages in thread From: Torres Cervantes, Salvador @ 2022-10-27 15:51 UTC (permalink / raw) To: Heikki Linnakangas <[email protected]>; [email protected] <[email protected]>; pgsql-odbc 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]> Sent: Thursday, October 27, 2022 8:18 AM To: [email protected]; Torres Cervantes, Salvador <[email protected]>; [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 Attachments: [image/png] image001.png (325.2K, 3-image001.png) download | view image ^ permalink raw reply [nested|flat] 12+ messages in thread
* RE: ODBC Driver for PostgreSQL @ 2022-11-01 16:27 Regina Obe <[email protected]> parent: Torres Cervantes, Salvador <[email protected]> 1 sibling, 1 reply; 12+ messages in thread From: Regina Obe @ 2022-11-01 16:27 UTC (permalink / raw) To: 'Torres Cervantes, Salvador' <[email protected]>; 'Heikki Linnakangas' <[email protected]>; [email protected]; pgsql-odbc 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:[email protected]] Sent: Thursday, October 27, 2022 11:51 AM To: Heikki Linnakangas <[email protected]>; [email protected]; [email protected] 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 <[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" < <mailto:[email protected]> [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 Attachments: [image/png] image002.png (4.5K, 3-image002.png) download | view image [image/jpeg] image003.jpg (72.7K, 4-image003.jpg) download | view image ^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: ODBC Driver for PostgreSQL @ 2022-11-02 05:51 Pierre Couderc <[email protected]> parent: Torres Cervantes, Salvador <[email protected]> 1 sibling, 1 reply; 12+ messages in thread From: Pierre Couderc @ 2022-11-02 05:51 UTC (permalink / raw) To: [email protected] 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 <[email protected]> > Sent: Thursday, October 27, 2022 8:18 AM > To: [email protected]; Torres Cervantes, Salvador > <[email protected]>; [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... Attachments: [image/png] image001.png (325.2K, 3-image001.png) download | view image ^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: ODBC Driver for PostgreSQL @ 2022-11-02 05:59 Pierre Couderc <[email protected]> parent: Pierre Couderc <[email protected]> 0 siblings, 1 reply; 12+ messages in thread From: Pierre Couderc @ 2022-11-02 05:59 UTC (permalink / raw) To: [email protected] 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 <[email protected]> >> Sent: Thursday, October 27, 2022 8:18 AM >> To: [email protected]; Torres Cervantes, Salvador >> <[email protected]>; [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 ! Attachments: [image/png] image001.png (325.2K, 3-image001.png) download | view image ^ permalink raw reply [nested|flat] 12+ messages in thread
* RE: ODBC Driver for PostgreSQL @ 2022-11-02 12:42 David Parenteau <[email protected]> parent: Pierre Couderc <[email protected]> 0 siblings, 1 reply; 12+ messages in thread From: David Parenteau @ 2022-11-02 12:42 UTC (permalink / raw) To: Pierre Couderc <[email protected]>; [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 ^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: ODBC Driver for PostgreSQL @ 2022-11-02 14:33 Pierre Couderc <[email protected]> parent: David Parenteau <[email protected]> 0 siblings, 1 reply; 12+ messages in thread From: Pierre Couderc @ 2022-11-02 14:33 UTC (permalink / raw) To: [email protected] 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... ^ permalink raw reply [nested|flat] 12+ messages in thread
* RE: ODBC Driver for PostgreSQL @ 2022-11-02 14:37 David Parenteau <[email protected]> parent: Pierre Couderc <[email protected]> 0 siblings, 0 replies; 12+ messages in thread From: David Parenteau @ 2022-11-02 14:37 UTC (permalink / raw) To: Pierre Couderc <[email protected]>; [email protected] <[email protected]> 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 <[email protected]> Sent: November 2, 2022 10:33 AM To: [email protected] 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. ^ permalink raw reply [nested|flat] 12+ messages in thread
* RE: ODBC Driver for PostgreSQL @ 2022-11-03 17:56 Torres Cervantes, Salvador <[email protected]> parent: Regina Obe <[email protected]> 0 siblings, 0 replies; 12+ messages in thread From: Torres Cervantes, Salvador @ 2022-11-03 17:56 UTC (permalink / raw) To: Regina Obe <[email protected]>; 'Heikki Linnakangas' <[email protected]>; [email protected] <[email protected]>; pgsql-odbc Hi Regina, I have created under System DSN. Let me test again. Thx, Salvador T. From: Regina Obe <[email protected]> Sent: Tuesday, November 1, 2022 9:27 AM To: Torres Cervantes, Salvador <[email protected]>; 'Heikki Linnakangas' <[email protected]>; [email protected]; [email protected] 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 [cid:[email protected]] From: Torres Cervantes, Salvador [mailto:[email protected]] Sent: Thursday, October 27, 2022 11:51 AM To: Heikki Linnakangas <[email protected]<mailto:[email protected]>>; [email protected]<mailto:[email protected]>; [email protected]<mailto:[email protected]> 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 [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 Attachments: [image/png] image001.png (4.5K, 3-image001.png) download | view image [image/jpeg] image002.jpg (72.7K, 4-image002.jpg) download | view image ^ permalink raw reply [nested|flat] 12+ messages in thread
end of thread, other threads:[~2022-11-03 17:56 UTC | newest] Thread overview: 12+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2022-10-27 14:47 ODBC Driver for PostgreSQL Torres Cervantes, Salvador <[email protected]> 2022-10-27 15:18 ` Heikki Linnakangas <[email protected]> 2022-10-27 15:25 ` Torres Cervantes, Salvador <[email protected]> 2022-10-27 15:28 ` Torres Cervantes, Salvador <[email protected]> 2022-10-27 15:51 ` Torres Cervantes, Salvador <[email protected]> 2022-11-01 16:27 ` Regina Obe <[email protected]> 2022-11-03 17:56 ` Torres Cervantes, Salvador <[email protected]> 2022-11-02 05:51 ` Pierre Couderc <[email protected]> 2022-11-02 05:59 ` Pierre Couderc <[email protected]> 2022-11-02 12:42 ` David Parenteau <[email protected]> 2022-11-02 14:33 ` Pierre Couderc <[email protected]> 2022-11-02 14:37 ` David Parenteau <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox