[ psqlodbc-Bugs-1000600 ] odbc via the local net (lan & Wan)

Bugs item #1000600, was opened at 2006-03-27 20:44
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000600&group_id=1000125

Category: Interface (example)
Group: v1.0 (example)
Status: Closed
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: odbc via the local net (lan & Wan)

Initial Comment:
When you have installed the odbc driver local where the db also is installed, it does work.

When you have istalled the odbc driver local on a client machine, the connection failed - it is always looking for the pg_hba.conf file.
-

log:
LIBPQ returned -> FATAL: missing or erroneous pg_hba.conf file
HINT: See server log for details.

[1452]CONN ERROR: func=PGAPI_DriverConnect, desc='Error from CC_Connect', errnum=113, sqlstate=08001, errmsg='FATAL: missing or erroneous pg_hba.conf file
HINT: See server log for details.
'
[1452][SQLGetDiagRecW]

----------------------------------------------------------------------

Comment By: Sorin Cristescu (scr53005)
Date: 2010-05-05 12:26

Message:
Hi,

I have the same problem. The pg_hba.conf is NOT missing and does NOT contain an error : the server works fine AND psqlODBC works fine AS LONG AS I set the "Server" as 127.0.0.1 when defining a psqlODBC-based DSN. BUT ... when I replace 127.0.0.1 with 10.128.54.77 (IP address of the Postgres server ...) I get a "missing or erroneous pg_hba.conf". The error is NOT reported by the server, it only appears when defining a DSN in odbcad32.exe

----------------------------------------------------------------------

Comment By: Dave Page (dpage)
Date: 2006-04-28 10:24

Message:
This error is being reported by the server because your pg_hba.conf file is missing or contains an error. This is not a psqlodbc problem.

----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000600&group_id=1000125