'Test' connection button gives no message, just an 'OK' button... and connection doesn't work - Mailing list pgsql-odbc

From Greg Cocks
Subject 'Test' connection button gives no message, just an 'OK' button... and connection doesn't work
Date
Msg-id 66F6CF82BF58CE4DB4285BE816B297E83BB01B@tribble.SMStoller.com
Whole thread Raw
Responses Re: 'Test' connection button gives no message, just an 'OK' button... and connection doesn't work
Re: 'Test' connection button gives no message, just an 'OK' button... and connection doesn't work
List pgsql-odbc

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

 

pgsql-odbc by date:

Previous
From: "Dave Page"
Date:
Subject: Re: need a help
Next
From: "Obe, Regina"
Date:
Subject: Re: 'Test' connection button gives no message, just an 'OK' button... and connection doesn't work