| From: | John VanDyk <jvandyk(at)iastate(dot)edu> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | ODBC and PostgreSQL 7.02 |
| Date: | 2000-06-12 18:50:55 |
| Message-ID: | v04220814b56adfcfb8b1@[129.186.120.53] |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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 using the 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 from the PostgreSQL setup? Why does it say there is no pg_hba.conf entry when there is?
John VanDyk
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gagan | 2000-06-12 19:44:54 | |
| Previous Message | Michael Ansley | 2000-06-12 13:18:10 | RE: query buffer max length of 16384 exceeded |