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

Re: Windows ODBC and a Router obstacle?

From: "Joseph Doench" <jdoench(at)cinci(dot)rr(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Windows ODBC and a Router obstacle?
Date: 2011-03-22 18:00:16
Message-ID: 003b01cbe8bb$00408d70$00c1a850$ (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Problem resolved.


Overlooked a silly mistake - a firewall setting.

Thanks for you time,

-----Original Message-----
From: pgsql-odbc-owner(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Philippe Lang
Sent: Tuesday, March 22, 2011 10:51 AM
To: Joseph Doench; pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] Windows ODBC and a Router obstacle?


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    :
Philippe Lang             phone  : +41 26 422 13 75
rte de la Fonderie 2      gsm    : +41 79 351 49 94
1700 Fribourg             twitter: @philippelang
                          pgp    : 

> -----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

pgsql-odbc by date

Next:From: Marco GaiarinDate: 2011-03-23 08:13:00
Subject: [ Centura 1.5.1: moving from ODBC 8 to 9, some trouble]
Previous:From: Philippe LangDate: 2011-03-22 14:50:51
Subject: Re: Windows ODBC and a Router obstacle?

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