sspi & odbc

--_000_CD8725E3E8BB8E45B71A3B6C222065F30874E3MAIL01inmailuni qu_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello,

Question, should it be possible to use sspi authentication in conjunction w=
ith odbc? The sspi is working using psql from a remote (windows) client, b=
ut 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 Unico=
de ODBC Driver.

Thanks for any assistance or insights

-Rob


--_000_CD8725E3E8BB8E45B71A3B6C222065F30874E3MAIL01inmailuni qu_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40"> =3D"text/html; charset=3Dus-ascii"> oft Word 14 (filtered medium)"> nk=3Dpurple>

Re: 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 =91ERROR [08001] authentication method 9 is not supported=92=
..

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


--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: sspi & odbc

Thanks, that is working for me, much appreciated. -Rob

-----Original Message-----
From: Hiroshi Inoue [mailto:inoue@tpf.co.jp]=20
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=20
> 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=20
> 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=20
> Unicode ODBC Driver.
>
> Thanks for any assistance or insights
>
> -Rob


--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc