Re: 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 remote location.

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(at)postgresql(dot)org [mailto:pgsql-odbc-
> owner(at)postgresql(dot)org] De la part de Joseph Doench
> Envoyé : mardi 8 mars 2011 19:02
> À : pgsql-odbc(at)postgresql(dot)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