| From: | Neal Lindsay <neal(dot)lindsay(at)peaofohio(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Trouble with pg_hba.conf and Access. |
| Date: | 2001-07-09 19:14:21 |
| Message-ID: | 5.1.0.14.0.20010709150554.00a0dec0@mail.peaofohio.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice 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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-07-09 19:43:25 | Re: Trouble with pg_hba.conf and Access. |
| Previous Message | A James Lewis | 2001-07-09 15:32:05 | Re: Postgres and Linux 7.1 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neal Lindsay | 2001-07-09 19:29:31 | Access97 problem with pg_hba.conf? |
| Previous Message | Jim Hines | 2001-07-09 19:14:10 | Re: Windows Connectivity Problems |