Thread: sspi & odbc
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
(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
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