From: Justin Jaynes <justinjaynes@hotmail.com>
To: pgsql-interfaces@postgresql.org
Subject: ODBC Connection Interface
Date: Mon, 17 Jul 2000 17:54:50 GMT
Message-ID: <20000717175450.7250.qmail@hotmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: justinjaynes@hotmail.com
Subject: Re: ODBC Connection Interface
In-Reply-To: <20000717175450.7250.qmail@hotmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox