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?