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.
Is this a common SNAFU to encounter?
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
