Peripheral Links
Header And Logo
Site Navigation
Re: 'Test' connection button gives no message, just an 'OK' button... and connection doesn't work
- From: "Greg Cocks" <gcocks(at)stoller(dot)com>
- To: "Obe, Regina" <robe(dot)dnd(at)cityofboston(dot)gov>
- Cc: <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 10:33:38 -0700
|
Thanks 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(dot)dnd(at)cityofboston(dot)gov] 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, From:
pgsql-odbc-owner(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of 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… ---------- |
- References:
- Prev by Date: Re: '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: Re: '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: