Re: Can't create DSN using SSPI authentication WinXP to WinXP - Mailing list pgsql-odbc

From Hiroshi Saito
Subject Re: Can't create DSN using SSPI authentication WinXP to WinXP
Date
Msg-id 20080430072224.z0000.z-saito@guitar.ocn.ne.jp
Whole thread Raw
In response to Can't create DSN using SSPI authentication WinXP to WinXP  ("Roger Quincy" <Roger.Quincy@twdb.state.tx.us>)
Responses Re: Can't create DSN using SSPI authentication WinXP to WinXP  ("Roger Quincy" <Roger.Quincy@twdb.state.tx.us>)
List pgsql-odbc
Hi.

Please use the installer package(08.03.0100).
Then, remove libpq.dll there. and use set SSL select of dialog.

Regards,
Hiroshi Saito

"Roger Quincy"
>I have posted this before and have a little more info but am still needing help.
>
>I have PostgreSQL 8.3.1 w32 running on Windows XP sp2 server.
>I want to authenticate using sspi for my Windows XP clients (domained) but while creating a DSN, I get an
"authenticationmethod 9 not supported" error message.  
>Here is a screenshot of the error message on the client while trying to create a DSN:
>http://pages.suddenlink.net/lt1/scnshot.jpg
>The error message dialog box pops up after clicking the Test button.
>
>If I change the entry in the pg_hba.conf file to from "sspi" to "trust", I can create the DSN with no problem. But,
usingtrust for multiple users is not secure enough. I am using the latest psqlODBC verson (8.03.01.00). 
>
>I have been told that the libpq library (libpq.dll) I  have doesn't support the functionality. And, that I need to
build a new libpq.dll with ENABLE_SSPI defined. 
>However, I am not a programmer and I don't know how to do this.
>Can anyone help me?
>
>Roger
>
>
>
>Roger M. Quincy, PG
>Hydrologist
>Texas Water Development Board
>Ground Water Technical Assistance Section
>phone: 512-936-0833
>email: rquincy@txwin.net
>web: http://www.twdb.state.tx.us/GwRD/waterwell/well_info.asp
>
>
>--
>Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-odbc

pgsql-odbc by date:

Previous
From: "Roger Quincy"
Date:
Subject: Can't create DSN using SSPI authentication WinXP to WinXP
Next
From: "Roger Quincy"
Date:
Subject: Re: Can't create DSN using SSPI authentication WinXP to WinXP