Peripheral Links
Header And Logo
Site Navigation
Re: 'Test' connection button gives no message, just an 'OK' button... and connection doesn't work
- From: "Obe, Regina" <robe(dot)dnd(at)cityofboston(dot)gov>
- To: "Greg Cocks" <gcocks(at)stoller(dot)com>, <pgsql-odbc(at)postgresql(dot)org>
- Subject: Re: 'Test' connection button gives no message, just an 'OK' button... and connection doesn't work
- Date: Tue, 15 Jan 2008 12:28:50 -0500
|
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… ---------- |
- Follow-Ups:
- References:
- Prev by Date: 'Test' connection button gives no message, just an 'OK' button... and connection doesn't work
- Next by Date: Re: 'Test' connection button gives no message, just an 'OK' button... and connection doesn't work
- Previous by thread: 'Test' connection button gives no message, just an 'OK' button... and connection doesn't work
- Next by thread: Re: 'Test' connection button gives no message, just an 'OK' button... and connection doesn't work
- Indexes: