Thread: Access97 problem with pg_hba.conf?

Access97 problem with pg_hba.conf?

From
Neal Lindsay
Date:
I am currently getting the following error when trying to connect to my
PostgreSQL server on my LAN via Microsoft Access and ODBC.

No pg_hba.conf entry for host 192.168.0.100, user neal, database mydb (#210)

The confusing thing is that I have set up my pg_hba.conf file in my data
directory. The actual text follows:

local all trust
host all 192.168.0.0 255.255.255.0 trust
host all 127.0.0.1 255.255.255.255 trust

I tried various other options, like enabling all hosts, and nothing seems
to work. Is this a quirk with Access 97?