Thanks Regina… please see my SUM…
I am off to check the file to see if the (previous) 192.168.0.122 that DHCP handed the client is in the range… I remember setting it for all 192.168.0.x addresses…
Cheers!
From: Obe, Regina [mailto:robe.dnd@cityofboston.gov]
Sent: Tuesday, January 15, 2008 10:29 AM
To: Greg Cocks; pgsql-odbc@postgresql.org
Subject: RE: [ODBC] 'Test' connection button gives no message, just an 'OK' button... and connection doesn't work
Did you check to make sure this pc is running the same ODBC driver version of PostgreSQL as the others? Could be a corrupted or incompatible ODBC driver. This info should be listed in ODBC Driver manager -> Drivers tab.
Did you verify that this computer is in your allowable ip range as defined in your Postgresql pg_hba.conf file? This computer may just be outside the ip range you defined and the others are within it. Maybe you can try psql or PgAdmin to see if it can connect by psql/libpq. If you can't connect by psql or PgAdmin, then most likely the pc is being blocked by PostgreSQL for some reason. If it can, then probably an isolated ODBC issue.
Actually the fact that the client PC can browse to shared directories just confirms that it can reach the server (not a network issue), but that doesn't necessarily mean the PostgreSQL service is allowing the pc to talk to it via the PostgreSQL service.
Hope that helps,
Regina
From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Greg Cocks
Sent: Tuesday, January 15, 2008 12:04 PM
To: pgsql-odbc@postgresql.org
Subject: [ODBC] 'Test' connection button gives no message, just an 'OK' button... and connection doesn't work
Hello,
I am setting up a user for ODBC access to a PostgreSQL server on the LAN, as I have done a few times before…
Using the same settings, quadruple-checked, system DNS – but the 'Test' connection gives no message, just the ‘!’ icon and an 'OK' button on just this one PC…
All clients are running XP Pro, SP2 and all up to date on other patches, etc
I opened up port 5432 and then turned the Windoze firewall totally off just in case it was that – no luck there…
This client PC can browse to the shared directories and change the allowed files on the server as expected, so seemingly not a windows permission thing…
Driver is v8.2.5…
And not surprisingly the Excel file with an ODBC link to selected data in the PostgreSQL database that works on other clients doesn’t here…
Very confused!
Any help much appreciated…
----------
Regards,
GREG COCKS
GIS Analyst V
gcocks |at| stoller.com
S. M. Stoller Corp
105 Technology Drive, Suite 190
Broomfield, CO 80021
www.stoller.com
303-546-4300
303-443-1408 fax
303-546-4422 direct
303-828-7576 cell