Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group