Обсуждение: sspi & odbc

Поиск
Список
Период
Сортировка

sspi & odbc

От
Robert Klaus
Дата:

Hello,

 

Question, should it be possible to use sspi authentication in conjunction with odbc?  The sspi is working using psql from a remote (windows) client, but when I try to use an odbc connection, it fails indicating ‘ERROR [08001] authentication method 9 is not supported’.

 

I am running version 8.4 of the server, and 8.04.02 of the Postgresql Unicode ODBC Driver.

 

Thanks for any assistance or insights

 

-Rob

 

Re: sspi & odbc

От
Hiroshi Inoue
Дата:
(2010/09/14 10:11), Robert Klaus wrote:
> Hello,
>
> Question, should it be possible to use sspi authentication in
> conjunction with odbc? The sspi is working using psql from a remote
> (windows) client, but when I try to use an odbc connection, it fails
> indicating ‘ERROR [08001] authentication method 9 is not supported’.

Please set the *SSL Mode* option to allow.
The driver would use libpq by the *SSL mode* option other than disable.

> I am running version 8.4 of the server, and 8.04.02 of the Postgresql
> Unicode ODBC Driver.
>
> Thanks for any assistance or insights
>
> -Rob


Re: sspi & odbc

От
Robert Klaus
Дата:
Thanks, that is working for me, much appreciated.  -Rob

-----Original Message-----
From: Hiroshi Inoue [mailto:inoue@tpf.co.jp]
Sent: Monday, September 13, 2010 11:49 PM
To: Robert Klaus
Cc: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] sspi & odbc

(2010/09/14 10:11), Robert Klaus wrote:
> Hello,
>
> Question, should it be possible to use sspi authentication in
> conjunction with odbc? The sspi is working using psql from a remote
> (windows) client, but when I try to use an odbc connection, it fails
> indicating 'ERROR [08001] authentication method 9 is not supported'.

Please set the *SSL Mode* option to allow.
The driver would use libpq by the *SSL mode* option other than disable.

> I am running version 8.4 of the server, and 8.04.02 of the Postgresql
> Unicode ODBC Driver.
>
> Thanks for any assistance or insights
>
> -Rob