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 <[EMAIL PROTECTED]> 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/
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
