Re: Can't create DSN using SSPI authentication WinXP to WinXP
- From: "Roger Quincy" <Roger(dot)Quincy(at)twdb(dot)state(dot)tx(dot)us>
- To: "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>
- Cc: <pgsql-odbc(at)postgresql(dot)org>
- Subject: Re: Can't create DSN using SSPI authentication WinXP to WinXP
- Date: Wed, 30 Apr 2008 08:37:12 -0500
- Message-id: <48182FB7(dot)EAE2(dot)00B3(dot)0(at)twdb(dot)state(dot)tx(dot)us>
No success.
I have been using 08.03.0100.
I deleted the libpq.dll like you say and then I get the following setting up the ODBC:
If I choose "Allow" in the SSL dialog, I get the error message "Unknown authorization type"
If I choose "Require" in the dialog, I get the error message "Could not construct a socket to the server"
Is there something I need to do on the server side?
I tried putting SSL=On in the postgresql.conf file on the server but the service would not restart after I did this.
In the pg_hba.conf file, I have been using "host all all 0.0.0.0 0.0.0.0 sspi"
Thanks,
Roger
Roger M. Quincy, PG
Hydrologist
Texas Water Development Board
Ground Water Technical Assistance Section
phone: 512-936-0833
email: rquincy(at)txwin(dot)net
web: http://www.twdb.state.tx.us/GwRD/waterwell/well_info.asp
>>> "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp> 4/29/2008 5:22 PM >>>
Hi.
Please use the installer package(08.03.0100).
Then, remove libpq.dll there. and use set SSL select of dialog.
Regards,
Hiroshi Saito
Home |
Main Index |
Thread Index