From: | "Joseph Doench" <jdoench(at)cinci(dot)rr(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Windows ODBC connection trouble? ISP issue? |
Date: | 2011-03-17 21:50:18 |
Message-ID: | 00c301cbe4ed$50b0d7a0$f21286e0$@rr.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
My home ISP, our cloud server, and the office ISP are all separate entities.
I infer that the problem is with the office ISP - DSL provided by a phone
company.
Regards,
JPD
-----Original Message-----
From: Adrian Klaver [mailto:adrian(dot)klaver(at)gmail(dot)com]
Sent: Thursday, March 17, 2011 5:44 PM
To: pgsql-general(at)postgresql(dot)org
Cc: Joseph Doench
Subject: Re: [GENERAL] Windows ODBC connection trouble? ISP issue?
On Thursday, March 17, 2011 2:29:00 pm Joseph Doench wrote:
> I have set up a pg database server for my organization on a cloud server
> using PG 8.2;
>
> I am trying to provide connections to the db for some members using MS
> Access. I developed a small MS Access application using Windows ODBC - it
> works fine from my house.
>
> I have this line in pg_hba.conf:
>
> Host all mydbuserID 0.0.0.0/0 password
>
> BUT. I cannot re-create the ODBC connection in our organization's offices!
>
>
> I have de-bugged by taking my laptop to the office - it will not connect
> to the db there - but is ok at my house.
> (I have also checked 2 other locations with public wi-fi; could not
connect
> from either of them)
>
> This seems to be related to the ISP blocking data - I have ruled out the
> router in the office.
When you say ISP do you mean the cloud provider or the service provider(s)
from
the various sites? I am assuming that that your home, office and the public
Wi-Fi
locations are not all using the same ISP.
>
> Is this a common SNAFU to encounter?
My guess is that the firewall rules on your cloud server is only allowing
connections from your home site.
>
> I spent an hour on the phone with tech support for the office's ISP; the
> guy insisted it could not be a problem on their side!
>
> Is there something I could be overlooking?
>
> Any help or guidance would be greatly appreciated.
>
>
> Regards,
>
> JPD
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2011-03-17 22:00:26 | Re: Windows ODBC connection trouble? ISP issue? |
Previous Message | Adrian Klaver | 2011-03-17 21:43:53 | Re: Windows ODBC connection trouble? ISP issue? |