Problem resolved.
DOH !
Overlooked a silly mistake - a firewall setting.
Thanks for you time,
JPD
-----Original Message-----
From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Philippe Lang
Sent: Tuesday, March 22, 2011 10:51 AM
To: Joseph Doench; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] Windows ODBC and a Router obstacle?
Hi,
Is your router configured with NAT maybe? If yes, the source IP of your packets is the one of the router, not the
remotelocation.
Try trusting everything from everywhere in your pg_hba.conf file, just to make sure it's a network problem...
-------------------------------------------------------------
Attik System web : http://www.attiksystem.ch
Philippe Lang phone : +41 26 422 13 75
rte de la Fonderie 2 gsm : +41 79 351 49 94
1700 Fribourg twitter: @philippelang
pgp : http://keyserver.pgp.com
> -----Message d'origine-----
> De : pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-
> owner@postgresql.org] De la part de Joseph Doench Envoyé : mardi 8
> mars 2011 19:02 À : pgsql-odbc@postgresql.org Objet : [ODBC] Windows
> ODBC and a Router obstacle?
>
> I am trying to connect to my PG 8.2 db server from MS Access from a
> remote location.
>
> I had configured PG to trust all connections from this location.
>
> i.e. in PG_HBA.conf I added a line containing:
>
> host all all ip-address/32 trust
>
> (and restarted the server)
>
> But I cannot get a connection.
>
> Could there be a problem with the local router in this location? What
> should I look for in the router set-up?
>
> JPD657