Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Interfaces Odbc > Can't create DS...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 8 Topic 2351 of 2383
Post > Topic >>

Can't create DSN using SSPI authentication WinXP to WinXP

by Roger.Quincy@[EMAIL PROTECTED] ("Roger Quincy") Apr 29, 2008 at 03:10 PM

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 "authentication method 9 not sup****ted"
erro=
r message.=20
Here is a screenshot of the error message on the client while trying to
cre=
ate a DSN:=20
http://pages.suddenlink.net/lt1/scnshot.jpg=20
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, using trust 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
sup****t=
 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@[EMAIL PROTECTED]
 http://www.twdb.state.tx.us/GwRD/waterwell/well_info.asp


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




 8 Posts in Topic:
Can't create DSN using SSPI authentication WinXP to WinXP
Roger.Quincy@[EMAIL PROTE  2008-04-29 15:10:14 
Re: Can't create DSN using SSPI authentication WinXP to WinXP
z-saito@[EMAIL PROTECTED]  2008-04-30 07:22:24 
Re: Can't create DSN using SSPI authentication WinXP to
Roger.Quincy@[EMAIL PROTE  2008-04-30 08:37:12 
Re: Can't create DSN using SSPI authentication WinXP toWinXP
z-saito@[EMAIL PROTECTED]  2008-04-30 23:44:35 
Re: Can't create DSN using SSPI authentication WinXP
Roger.Quincy@[EMAIL PROTE  2008-05-08 06:46:13 
Re: Can't create DSN using SSPI authentication WinXP
Roger.Quincy@[EMAIL PROTE  2008-04-30 11:12:12 
Re: Can't create DSN using SSPI authentication WinXP toWinXP
z-saito@[EMAIL PROTECTED]  2008-05-01 07:16:37 
Re: Can't create DSN using SSPI authentication WinXP toWinXP
jokwara@[EMAIL PROTECTED]  2008-04-30 19:48:07 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 20 4:27:51 CDT 2008.