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

Re: Windows ODBC and a Router obstacle?

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: Joseph Doench <jdoench(at)cinci(dot)rr(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Windows ODBC and a Router obstacle?
Date: 2011-03-08 18:30:33
Message-ID: 4D7675C9.5070105@gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
On 03/08/2011 10:01 AM, Joseph Doench wrote:
> I am trying to connect to my PG 8.2 dbserverfrom MS Accessfroma remote
> location.
>
> I had configured PG to trust all connections from this location.
>
> i.e. in PG_HBA.confI 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
>

A couple of questions:

What does the Postgres log show when you try to connect?
Do you have another way to connect to the Postgres server from the 
Access machine and have you tried it?
	Specifically have you tried using psql to connect?


-- 
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Responses

pgsql-odbc by date

Next:From: Joseph DoenchDate: 2011-03-09 00:25:31
Subject: Re: Windows ODBC and a Router obstacle?
Previous:From: Joseph DoenchDate: 2011-03-08 18:01:49
Subject: Windows ODBC and a Router obstacle?

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