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: 2008-04-30 13:37:12
Message-ID: 48182FB7.EAE2.00B3.0@twdb.state.tx.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Saito 2008-04-30 14:44:35 Re: Can't create DSN using SSPI authentication WinXP toWinXP
Previous Message Hiroshi Saito 2008-04-29 22:22:24 Re: Can't create DSN using SSPI authentication WinXP to WinXP