"Test" connection button gives no message, just an "OK" button... and connection doesn"t work

This is a multi-part message in MIME format.

------_=_NextPart_001_01C85798.AF1D50EA
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello,

=20

I am setting up a user for ODBC access to a PostgreSQL server on the
LAN, as I have done a few times before...

=20

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...

=20

All clients are running XP Pro, SP2 and all up to date on other patches,
etc

=20

I opened up port 5432 and then turned the Windoze firewall totally off
just in case it was that - no luck there...

=20

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...

=20

Driver is v8.2.5...

=20

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...

=20

Very confused!

=20

Any help much appreciated...

=20

----------
Regards,
GREG COCKS
GIS Analyst V
gcocks |at| stoller.com =20
S. M. Stoller Corp
105 Technology Drive, Suite 190
Broomfield, CO 80021
www.stoller.com =20
303-546-4300
303-443-1408 fax
303-546-4422 direct
303-828-7576 cell

=20


------_=_NextPart_001_01C85798.AF1D50EA
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40">


charset=3Dus-ascii">

namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"PostalCode"/>
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"State"/>
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"City"/>
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place"/>
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"Street"/>
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"address"/>

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

This is a multi-part message in MIME format.


------_=_NextPart_001_01C8579C.17E38571
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Did you check to make sure this pc is running the same ODBC driver ver=
sion of PostgreSQL as the others? Could be a corrupted or incompatibl=
e ODBC driver This info should be listed in ODBC Driver manager ->=
Drivers tab. =0A Did you verify that this computer is in your al=
lowable ip range as defined in your Postgresql pg_hbaconf file? Thi=
s 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, the=
n most likely the pc is being blocked by PostgreSQL for some reason=
If it can, then probably an isolated ODBC issue. =0A Actua=
lly 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. =0A Hope that helps, =
Regina ________________________________ From : =
pgsql-odbc-owner@postgresqlorg [mailto:pgsql-odbc-ow ner@postgresql=
org] On Behalf Of Greg Cocks Sent: Tuesday, January 15, 2008 12:04 =
PM To: pgsql-odbc@postgresqlorg Subject: [ODBC] 'Test' connect=
ion button gives no message, just an 'OK' button.. and connecti=
on doesn't work Hello, I am =
setting up a user for ODBC access to a PostgreSQL server on the LAN, a=
s I have done a few times before... =0A Using the=
same settings, quadruple-checked, system DNS - but the 'Test' connect=
ion gives no message, just the '!' icon and an 'OK' button on just thi=
s one PC... =0A All clients are running XP Pro, S=
P2 and all up to date on other patches, etc I =
opened up port 5432 and then turned the Windoze firewall totally off j=
ust in case it was that - no luck there... =0A Th=
is client PC can browse to the shared directories and change the allow=
ed files on the server as expected, so seemingly not a windows permiss=
ion thing... =0A Driver is v825... =
=0A And not surprisingly the Excel file with an ODBC link=
to selected data in the PostgreSQL database that works on other clien=
ts doesn't here... =0A Very confused! =
Any help much appreciated... =0A ---=
------- Regards, GREG COCKS GIS Analyst V gcocks |at| s=
tollercom S M Stoller=
Corp 105 Technology Drive, Suite 190 Broomfield, CO 80021 w=
wwstollercom 303-546-430=
0 303-443-1408 fax 303-546-4422 direct 303-828-7576 cell=0D=
=0A ------------------------------------ -----=
The substance of this message, including any attachments, may be=0Aco=
nfidential, legally privileged and/or exempt from disclosure=0Apursuant to =
Massachusetts law It is intended solely for the addressee If you=
received this in error, please=0Acontact the sender and delete the materia=
l from any computer. =0A
------_=_NextPart_001_01C8579C.17E38571
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns=3D"http://wwww3org/TR/REC-html40" xmlns:o =3D "urn:schem=
as-microsoft-com:office:office" xmlns:w =3D "urn:schemas-microsoft-co=
m:office:word" xmlns:st1 =3D "urn:schemas-microsoft-com:office:smartt=
ags"> set=3Dus-ascii"> =3DGENERATOR> =3D"urn:schemas-microsoft-com:office:smarttags"> gType name=3D"State" namespaceuri=3D"urn:schemas-microsoft-com:=
office:smarttags"> =0Anamespaceuri=3D"urn:schemas-microsoft-com:office:smarttag s"> Type> -microsoft-com:office:smarttags"> e=3D"Street" namespaceuri=3D"urn:schemas-microsoft-com:office:smart ta=
gs"> uri=3D"urn:schemas-microsoft-com:office:smarttags"> ple link=3Dblue>