On Thu, Jul 15, 2010 at 11:34 AM, Joseph Doench <jdoench@cinci.rr.com> wrote:
> FYI, I am running Access 2007.
>
> I’ve read some of the PG documentation…
>
> checked and confirmed that:
>
> posgreSQL.conf contains listen_addresses='*'.
>
> Added a line to pg_hba.conf containing:
>
> host all all myIPaddress trust
>
> …using ‘postgres’ or ‘projop’ for the database name.
>
> …using ‘postgres’ as the username; no password
>
> Getting an error message: 'No connection could be made because the target
> machine actively refused it.’
Are you able to log in locally using psql with these credentials?
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug