Message-ID: <20000717175450.7250.qmail@hotmail.com>
From: "Justin Jaynes" <justinjaynes@hotmail.com>
To: pgsql-interfaces@postgresql.org
Subject: ODBC Connection Interface
Date: Mon, 17 Jul 2000 17:54:50 GMT
Mime-Version: 1.0
Content-Type: text/plain; format=flowed

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