SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-17-2008, 04:27 PM
| ||||
| ||||
 Can't create DSN using SSPI authentication WinXP to WinXP 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 supported" error message. However, connecting with the pgAdmin III works fine. 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, using trust for multiple users is not secure enough. I am using the latest psqlODBC verson (8.03.01.00). I am not a programmer so I need to know if there is an easy fix for this. Can anyone help me? Roger -- Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-odbc      |
|
04-17-2008, 04:27 PM
| ||||
| ||||
| Re: Can't create DSN using SSPI authentication WinXP to WinXP Roger Quincy wrote: > 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 supported" error message. However, connecting with the pgAdmin III works fine. > 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, using trust for multiple users is not secure enough. I am using the latest psqlODBC verson (8.03.01.00). > > I am not a programmer so I need to know if there is an easy fix for this. > Can anyone help me? Could you try to select the *allow* SSL Mode ? regards, Hiroshi Inoue -- Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-odbc |
 |
« Access issue again
|
Re: connection problem with postgresql driver 8.03.0100 to postgresql 8.3.0 »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
All times are GMT. The time now is 11:38 AM.
