| From: | "Justin Jaynes" <justinjaynes(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | ODBC Connection Interface |
| Date: | 2000-07-17 17:54:50 |
| Message-ID: | 20000717175450.7250.qmail@hotmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
Hello,
I am trying to connect to a remote PostgreSQL server using Microsoft FoxPro
so I can move the database. I have set up the new database on the remote
machine, and started the postmaster as a service on powerup. I have added
the line:
host all 0.0.0.0 0.0.0.0 trust
in my pg_hba.conf file under /usr/pgdata directory where I set my databases
up.
Now I go onto the windows machine and in ODBC manager I set up the
connection with the username and password of a linux account.
I go into foxpro and try to set up a new connection using that ODBC source
and choose "Verify Connection." The server is reached, but returns the
error:
No pg_hba.conf entry for host [my ip for dialup on the windows machine],
user [username], database [database name]
Do you know why this happens, and how to fix it?
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin Jaynes | 2000-07-17 20:45:52 | ODBC Connections Fixed. Wrong pg_hba |
| Previous Message | Thomas Lockhart | 2000-07-17 05:43:37 | Re: more ODBC driver |