Thread: ODBC and PostgreSQL 7.02

ODBC and PostgreSQL 7.02

From
John VanDyk
Date:
My goal is to set up Postgres 7 on Red Hat 6.2 and access it via ODBC from an NT machine.

I've set up PostgreSQL 7.02 (via the RPM) and it seems to be working. I can create the test database and manipulate it
usingthe pgsql test command. 

I have a pg_hba.conf file in /var/lib/pgsql with a line that looks like this

host         all         1.2.3.4 255.255.255.0      trust

where 1.2.3.4 is the IP of my NT machine. I set up the ODBC driver and I can do a query but get the response from the
postmaster

No pg_hba.conf entry for host 1.2.3.4, user skippy, database test

I am using the Insight ODBC driver version 6.50. Does this driver not work with PostgreSQL 7.02? Am I missing something
fromthe PostgreSQL setup? Why does it say there is no pg_hba.conf entry when there is? 

John VanDyk