Be sure you've supplied the username, password and
database name when connecting, also check to see you
don't have a �reject� policy that may impede your
connection attempt.
Be sure to instruct postgresql to reload the
configuration files once you've modified the
pg_hba.conf file.
You may start by adding line similar to this at the
end of your pg_hba.conf file.
host all all
<your_client's_ip_address>/32 password
Where �your_client's_ip_address� will be the IP
address of the computer your attempting to connect to
PostgreSQL from, in your case it will be the computer
your running M$ Access from.
Allan.
--- Maritza Landsberg <jesse@cks.co.za> wrote:
> Hi
>
> I need help with the following error I am getting
> when trying to connect
> with Microsoft Access to my Postgresql database.
>
> FATAL 1: No host found in pg_hba.conf for IP
> address, database name,
> postgres user...
>
> I have changed the pg_hba.conf to include the IP
> address.
>
> Please could someone assist me with this?
>
> Thanks
>
> Maritza Landsberg
>
>
__________________________________
Do you Yahoo!?
Yahoo! Sports - Sign up for Fantasy Baseball.
http://baseball.fantasysports.yahoo.com/