Re: 'Test' connection button gives no message, just an 'OK' button... and connection doesn't work

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!

Regards,

GREG COCKS

gcocks(at)stoller(dot)com <mailto:gcocks(at)stoller(dot)com>

________________________________

From: Obe, Regina [mailto:robe(dot)dnd(at)cityofboston(dot)gov]
Sent: Tuesday, January 15, 2008 10:29 AM
To: Greg Cocks; pgsql-odbc(at)postgresql(dot)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(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Greg Cocks
Sent: Tuesday, January 15, 2008 12:04 PM
To: pgsql-odbc(at)postgresql(dot)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 <blocked::mailto:gcocks(at)stoller(dot)com>
S. M. Stoller Corp
105 Technology Drive, Suite 190
Broomfield, CO 80021
www.stoller.com <blocked::http://www.stoller.com/>
303-546-4300
303-443-1408 fax
303-546-4422 direct
303-828-7576 cell