Skip site navigation (1) Skip section navigation (2)

Re: Windows ODBC and a Router obstacle?

From: Philippe Lang <philippe(dot)lang(at)attiksystem(dot)ch>
To: Joseph Doench <jdoench(at)cinci(dot)rr(dot)com>, "pgsql-odbc(at)postgresql(dot)org"<pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Windows ODBC and a Router obstacle?
Date: 2011-03-22 14:50:51
Message-ID: 8AE5A725DAF7364F97FF75D99E45B65779279B9E@SBS1.attiksystem.local (view raw or flat)
Thread:
Lists: 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 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

In response to

Responses

pgsql-odbc by date

Next:From: Joseph DoenchDate: 2011-03-22 18:00:16
Subject: Re: Windows ODBC and a Router obstacle?
Previous:From: Julius TuskenisDate: 2011-03-18 07:23:25
Subject: Re: odbc 9.0.200 on delphi

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group