Re: Windows ODBC and a Router obstacle? - Mailing list pgsql-odbc

From Philippe Lang
Subject Re: Windows ODBC and a Router obstacle?
Date
Msg-id 8AE5A725DAF7364F97FF75D99E45B65779279B9E@SBS1.attiksystem.local
Whole thread Raw
In response to Windows ODBC and a Router obstacle?  ("Joseph Doench" <jdoench@cinci.rr.com>)
Responses Re: Windows ODBC and a Router obstacle?  ("Joseph Doench" <jdoench@cinci.rr.com>)
List pgsql-odbc
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


Attachment

pgsql-odbc by date:

Previous
From: Julius Tuskenis
Date:
Subject: Re: odbc 9.0.200 on delphi
Next
From: "Joseph Doench"
Date:
Subject: Re: Windows ODBC and a Router obstacle?