Skip site navigation (1) Skip section navigation (2)

Access97 problem with pg_hba.conf?

From: Neal Lindsay <neal(dot)lindsay(at)peaofohio(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Access97 problem with pg_hba.conf?
Date: 2001-07-09 19:29:31
Message-ID: 5.1.0.14.0.20010709152811.009d1630@mail.peaofohio.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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?


pgsql-odbc by date

Next:From: Tom LaneDate: 2001-07-09 19:43:25
Subject: Re: Trouble with pg_hba.conf and Access.
Previous:From: Neal LindsayDate: 2001-07-09 19:14:21
Subject: Trouble with pg_hba.conf and Access.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group