'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,

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

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

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
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">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"PostalCode"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"State"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"City"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"Street"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"address"/>

<style>

</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

Hello,<o:p></o:p>

<o:p> </o:p>

I am setting up a user for ODBC access to a =
PostgreSQL
server on the LAN, as I have done a few times =
before…<o:p></o:p>

<o:p> </o:p>

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…<o:p></o:p>

<o:p> </o:p>

All clients are running XP Pro, SP2 and all up to =
date on
other patches, etc<o:p></o:p>

<o:p> </o:p>

I opened up port 5432 and then turned the Windoze =
firewall totally
off just in case it was that – no luck =
there…<o:p></o:p>

<o:p> </o:p>

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…<o:p></o:p>

<o:p> </o:p>

Driver is v8.2.5…<o:p></o:p>

<o:p> </o:p>

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…<o:p></o:p>

<o:p> </o:p>

Very confused!<o:p></o:p>

<o:p> </o:p>

Any help much =
appreciated…<o:p></o:p>

<o:p> </o:p>

---------- 
Regards, 
GREG =
COCKS 
GIS =
Analyst V 
<a href=3D"blocked::mailto:gcocks [at] stoller.com"
title=3D"blocked::mailto:gcocks [at] stoller.com">gcocks
|at| stoller.com</a> 
S. M. Stoller Corp 
<st1:Street w:st=3D"on"><st1:address w:st=3D"on">105 Technology Drive, =
Suite 190</st1:address></st1:Street> 
<st1:place w:st=3D"on"><st1:City w:st=3D"on">Broomfield</st1:City>, =
<st1:State
w:st=3D"on">CO</st1:State> <st1:PostalCode =
w:st=3D"on">80021</st1:PostalCode></st1:place> 
<a href=3D"blocked::http://www.stoller.com/"
title=3D"blocked::http://www.stoller.com/">www.stoller.com</a> 
303-546-4300 
303-443-1408 fax 
303-546-4422 direct 
303-828-7576 cell<o:p></o:p>

<o:p> </o:p>

</div>

</body>

</html>

------_=_NextPart_001_01C85798.AF1D50EA--

Greg Cocks [ Di, 15 Januar 2008 18:04 ] [ ID #1908211 ]

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=0D=0Aver=
sion of PostgreSQL as the others? Could be a corrupted or=0D=0Aincompatibl=
e ODBC driver=2E This info should be listed in ODBC Driver=0D=0Amanager ->=
Drivers tab=2E=0D=0A =0D=0ADid you verify that this computer is in your al=
lowable ip range as=0D=0Adefined in your Postgresql pg_hba=2Econf file? Thi=
s computer may just be=0D=0Aoutside the ip range you defined and the others=
are within it=2E Maybe you=0D=0Acan try psql or PgAdmin to see if it can =
connect by psql/libpq=2E If you=0D=0Acan't connect by psql or PgAdmin, the=
n most likely the pc is being=0D=0Ablocked by PostgreSQL for some reason=2E=
If it can, then probably an=0D=0Aisolated ODBC issue=2E=0D=0A =0D=0AActua=
lly the fact that the client PC can browse to shared directories=0D=0Ajust =
confirms that it can reach the server (not a network issue), but=0D=0Athat =
doesn't necessarily mean the PostgreSQL service is allowing the pc=0D=0Ato =
talk to it via the PostgreSQL service=2E=0D=0A =0D=0AHope that helps,=0D=0A=
Regina=0D=0A =0D=0A=0D=0A________________________________=0D=0A=0D=0AFrom : =
pgsql-odbc-owner [at] postgresql=2Eorg=0D=0A[mailto:pgsql-odbc-ow ner [at] postgresql=
=2Eorg] On Behalf Of Greg Cocks=0D=0ASent: Tuesday, January 15, 2008 12:04 =
PM=0D=0ATo: pgsql-odbc [at] postgresql=2Eorg=0D=0ASubject: [ODBC] 'Test' connect=
ion button gives no message, just an 'OK'=0D=0Abutton=2E=2E=2E and connecti=
on doesn't work=0D=0A=0D=0A=0D=0A=0D=0AHello,=0D=0A=0D=0A =0D=0A=0D=0AI am =
setting up a user for ODBC access to a PostgreSQL server on the=0D=0ALAN, a=
s I have done a few times before=2E=2E=2E=0D=0A=0D=0A =0D=0A=0D=0AUsing the=
same settings, quadruple-checked, system DNS - but the 'Test'=0D=0Aconnect=
ion gives no message, just the '!' icon and an 'OK' button on=0D=0Ajust thi=
s one PC=2E=2E=2E=0D=0A=0D=0A =0D=0A=0D=0AAll clients are running XP Pro, S=
P2 and all up to date on other patches,=0D=0Aetc=0D=0A=0D=0A =0D=0A=0D=0AI =
opened up port 5432 and then turned the Windoze firewall totally off=0D=0Aj=
ust in case it was that - no luck there=2E=2E=2E=0D=0A=0D=0A =0D=0A=0D=0ATh=
is client PC can browse to the shared directories and change the=0D=0Aallow=
ed files on the server as expected, so seemingly not a windows=0D=0Apermiss=
ion thing=2E=2E=2E=0D=0A=0D=0A =0D=0A=0D=0ADriver is v8=2E2=2E5=2E=2E=2E=0D=
=0A=0D=0A =0D=0A=0D=0AAnd not surprisingly the Excel file with an ODBC link=
to selected data=0D=0Ain the PostgreSQL database that works on other clien=
ts doesn't here=2E=2E=2E=0D=0A=0D=0A =0D=0A=0D=0AVery confused!=0D=0A=0D=0A=
=0D=0A=0D=0AAny help much appreciated=2E=2E=2E=0D=0A=0D=0A =0D=0A=0D=0A---=
-------=0D=0ARegards,=0D=0AGREG COCKS=0D=0AGIS Analyst V=0D=0Agcocks |at| s=
toller=2Ecom <blocked::mailto:gcocks [at] stoller=2Ecom> =0D=0AS=2E M=2E Stoller=
Corp=0D=0A105 Technology Drive, Suite 190=0D=0ABroomfield, CO 80021=0D=0Aw=
ww=2Estoller=2Ecom <blocked::http://www=2Estoller=2Ecom/> =0D=0A303-546-430=
0=0D=0A303-443-1408 fax=0D=0A303-546-4422 direct=0D=0A303-828-7576 cell=0D=
=0A=0D=0A =0D=0A=0D=0A=0D=0A=0D=0A------------------------------------ -----=
=0D=0AThe substance of this message, including any attachments, may be=0Aco=
nfidential, legally privileged and/or exempt from disclosure=0Apursuant to =
Massachusetts law=2E It is intended=0D=0Asolely for the addressee=2E If you=
received this in error, please=0Acontact the sender and delete the materia=
l from any computer=2E=0D=0A
------_=_NextPart_001_01C8579C.17E38571
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4=2E0 Transitional//EN">=0D=0A<HTML=
xmlns=3D"http://www=2Ew3=2Eorg/TR/REC-html40" xmlns:o =3D =0D=0A"urn:schem=
as-microsoft-com:office:office" xmlns:w =3D =0D=0A"urn:schemas-microsoft-co=
m:office:word" xmlns:st1 =3D =0D=0A"urn:schemas-microsoft-com:office:smartt=
ags"><HEAD>=0D=0A<META http-equiv=3DContent-Type content=3D"text/html; char=
set=3Dus-ascii">=0D=0A<META content=3D"MSHTML 6=2E00=2E6000=2E16481" name=
=3DGENERATOR><o:SmartTagType =0D=0Aname=3D"PostalCode" =0D=0Anamespaceuri=
=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTa=
gType =0D=0Aname=3D"State" =0D=0Anamespaceuri=3D"urn:schemas-microsoft-com:=
office:smarttags"></o:SmartTagType><o:SmartTagType =0D=0Aname=3D"City" =0D=
=0Anamespaceuri=3D"urn:schemas-microsoft-com:office:smarttag s"></o:SmartTag=
Type><o:SmartTagType =0D=0Aname=3D"place" =0D=0Anamespaceuri=3D"urn:schemas=
-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType =0D=0Anam=
e=3D"Street" =0D=0Anamespaceuri=3D"urn:schemas-microsoft-com:office:smart ta=
gs"></o:SmartTagType><o:SmartTagType =0D=0Aname=3D"address" =0D=0Anamespace=
uri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType>=0D=0A<STYLE> [at] page Section1 {size: 8=2E5in 11=
=2E0in; margin: 1=2E0in 1=2E25in 1=2E0in 1=2E25in; }=0D=0AP=2EMsoNormal {=
=0D=0A FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"=
=0D=0A}=0D=0ALI=2EMsoNormal {=0D=0A FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; F=
ONT-FAMILY: "Times New Roman"=0D=0A}=0D=0ADIV=2EMsoNormal {=0D=0A FONT-SIZE=
: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"=0D=0A}=0D=0AA:l=
ink {=0D=0A COLOR: blue; TEXT-DECORATION: underline=0D=0A}=0D=0ASPAN=2EMsoH=
yperlink {=0D=0A COLOR: blue; TEXT-DECORATION: underline=0D=0A}=0D=0AA:visi=
ted {=0D=0A COLOR: purple; TEXT-DECORATION: underline=0D=0A}=0D=0ASPAN=2EMs=
oHyperlinkFollowed {=0D=0A COLOR: purple; TEXT-DECORATION: underline=0D=0A}=
=0D=0ASPAN=2EEmailStyle17 {=0D=0A COLOR: windowtext; FONT-FAMILY: Arial; ms=
o-style-type: personal-compose=0D=0A}=0D=0ADIV=2ESection1 {=0D=0A page: Sec=
tion1=0D=0A}=0D=0A</STYLE>=0D=0A</HEAD>=0D=0A<BODY lang=3DEN-US vLink=3Dpur=
ple link=3Dblue>=0D=0A<DIV dir=3Dltr align=3Dleft>Did you check to =
make sure this pc is running the same ODBC =0D=0Adriver version of PostgreS=
QL as the others? Could be a corrupted or =0D=0Aincompatible ODBC dri=
ver=2E This info should be listed in ODBC Driver =0D=0Amanager -> =
Drivers tab=2E</DIV>=0D=0A<DIV dir=3Dltr align=3Dleft> </DIV>=0D=0A<DIV dir=3Dltr align=3Dleft>Did </=
FONT>you verify that this computer is in your =0D=0Aallowabl=
e ip range as defined in your Postgresql pg_hba=2Econf file? This computer =
=0D=0Amay just be outside the ip range you defined and the others are withi=
n =0D=0Ait=2E Maybe you can try psql or PgAdmin to see if it can=
connect by =0D=0Apsql/libpq=2E If you can't connect by psql or PgAdm=
in, then most likely the =0D=0Apc is being blocked by PostgreSQL for some r=
eason=2E If it can, then =0D=0Aprobably an isolated ODBC issue=2E</FO=
NT></DIV>=0D=0A<DIV dir=3Dltr align=3Dleft>&nb=
sp;</DIV>=0D=0A<DIV dir=3Dltr align=3Dleft>Actually the fact that t=
he client PC can browse to shared =0D=0Adirectories just confirms that it c=
an reach the server (not a network issue), =0D=0Abut that doesn't necessari=
ly mean the PostgreSQL service is allowing the pc to =0D=0Atalk to it via t=
he PostgreSQL service=2E</DIV>=0D=0A<DIV dir=3Dltr align=3Dle=
ft> </DIV>=0D=0A<DIV dir=3Dltr align=3Dleft><SPA=
N class=3D255541517-15012008>Hope that helps,</DIV>=0D=0A<DIV dir=3Dltr align=3Dleft>=
Regina</DIV>=0D=0A<DIV dir=3Dltr align=3Dleft> </DIV> =0D=0A<DIV class=3DOutlookMessageHeader lang=
=3Den-us dir=3Dltr align=3Dleft>=0D=0A<HR tabIndex=3D-1>=0D=0AFrom: pgsql-odbc-owner [at] postgresql=2Eorg =0D=0A[mailt=
o:pgsql-odbc-owner [at] postgresql=2Eorg] On Behalf Of Greg =0D=0ACocks<B=
R>Sent: Tuesday, January 15, 2008 12:04 PM To: =0D=0Apgsql=
-odbc [at] postgresql=2Eorg Subject: [ODBC] 'Test' connection button =
=0D=0Agives no message, just an 'OK' button=2E=2E=2E and connection doesn't=
=0D=0Awork </DIV>=0D=0A<DIV></DIV>=0D=0A<DIV class=3DSection=
1>=0D=0AHello,<o:p></o:p></P=
>=0D=0A<o:p> </o:p></P=
>=0D=0AI am setting up a user for ODBC =
=0D=0Aaccess to a PostgreSQL server on the LAN, as I have done a few times =
=0D=0Abefore…<o:p></o:p>=0D=0A=
<o:p> </o:p>=0D=0A<F=
ONT face=3DArial size=3D2>Using the same settings, =0D=0Aquadruple-checked, system DNS ̵=
1; but the 'Test' connection gives no message, just =0D=0Athe ‘!̵=
7; icon and an 'OK' button on just this one =0D=0APC…<o:p></o:p></SPA=
N>=0D=0A<o:p> </o:p></SPAN=
>=0D=0AAll clients are running=
XP Pro, SP2 =0D=0Aand all up to date on other patches, etc<o:p></o:p></SPA=
N>=0D=0A<o:p> </o:p></SPAN=
>=0D=0AI opened up port 5432 a=
nd then =0D=0Aturned the Windoze firewall totally off just in case it was t=
hat – no luck =0D=0Athere…<o:p></o:p>=0D=0A<P=
class=3DMsoNormal><o:p> </o:p>=0D=0AThis client PC can browse to the =0D=0Ashared d=
irectories and change the allowed files on the server as expected, so =0D=
=0Aseemingly not a windows permission thing…<o:p></o:p>=
=0D=0A<o:p> </o:p></=
P>=0D=0ADriver is =0D=0Av8=2E2=2E5…<=
o:p></o:p>=0D=0A<o:p>&nbs=
p;</o:p>=0D=0AAnd not sur=
prisingly the Excel file =0D=0Awith an ODBC link to selected data in the Po=
stgreSQL database that works on =0D=0Aother clients doesn’t here̷=
0;<o:p></o:p>=0D=0A<o:p>&=
nbsp;</o:p>=0D=0AVery =0D=
=0Aconfused!<o:p></o:p>=0D=0A<o:p> </o:p>=0D=0AAny help much =0D=0Aappreciated…<o:p></o:p>=0D=0A=
<o:p> </o:p>=0D=0A<P=
class=3DMsoNormal =0D=0Astyle=3D"mso-margin-top-alt: auto; mso-margin-bott=
om-alt: auto">---------- Regards, <=
B>GREG =0D=0ACOCKS</S=
TRONG> GIS Analyst V <A =0D=0Atitle=3Dblocked::mailto:g=
cocks [at] stoller=2Ecom =0D=0Ahref=3D"blocked::mailto:gcocks [at] stoller=2Ecom"><FO=
NT =0D=0Atitle=3Dblocked::mailto:gcocks [at] stoller=2Ecom size=3D1>gcocks =0D=0A|at| stoller=2Ecom</A> S=2E M=2E Stoller Corp <st=
1:Street =0D=0Aw:st=3D"on"><st1:address w:st=3D"on">105 Technology Drive, S=
uite =0D=0A190</st1:address></st1:Street> <st1:place w:st=3D"on"><st1:Ci=
ty =0D=0Aw:st=3D"on">Broomfield</st1:City>, <st1:State w:st=3D"on">CO</st1:=
State> =0D=0A<st1:PostalCode w:st=3D"on">80021</st1:PostalCode></st1:place>=
 <A =0D=0Atitle=3Dblocked::http://www=2Estoller=2Ecom/ =0D=
=0Ahref=3D"blocked::http://www=2Estoller=2Ecom/">www=2Estolle=
r=2Ecom</A> 303-546-4300 303-443-1408 =0D=0Afax 303-546-4422 dir=
ect 303-828-7576 cell<o:p></o:p>=0D=0A<o:p> </o:p></DIV></BODY></HTML>=0D=0A=0D=0A
------_=_NextPart_001_01C8579C.17E38571--

robe.dnd [ Di, 15 Januar 2008 18:28 ] [ ID #1908212 ]

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.C3A97AFA
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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.com <mailto:gcocks [at] stoller.com>

________________________________

From: Obe, Regina [mailto:robe.dnd [at] cityofboston.gov]
Sent: Tuesday, January 15, 2008 10:29 AM
To: Greg Cocks; pgsql-odbc [at] postgresql.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.org
[mailto:pgsql-odbc-owner [at] postgresql.org] On Behalf Of Greg Cocks
Sent: Tuesday, January 15, 2008 12:04 PM
To: pgsql-odbc [at] postgresql.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.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

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

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
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">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<o:SmartTagType
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" =
name=3D"PostalCode"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"State"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"City"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"Street"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"address"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"PersonName"/>

<style>

</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

Thanks <st1:City =
w:st=3D"on"><st1:place
w:st=3D"on">Regina</st1:place></st1:City>… please see my =
SUM…<o:p></o:p>

<o:p> </o:p>

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…<o:p></o:p>

<o:p> </o:p>

Cheers! =
<o:p></o:p>

<o:p> </o:p>

<div>

Regards,<font=

color=3Dnavy><o:p></o:p>

GREG =
COCKS<o:p></o:p>

<a =
href=3D"mailto:gcocks [at] stoller.com"
title=3D"blocked::mailto:gcocks [at] stoller.com">gcocks [at] stoller. com</s=
pan></a><o:p></o:p>

<o:p> </o:p>

</div>

<div>

<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'>

<hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1>

</div>

From: Obe, =
Regina
[mailto:robe.dnd [at] cityofboston.gov] 
Sent: Tuesday, January =
15, 2008
10:29 AM 
To: <st1:PersonName =
w:st=3D"on">Greg
Cocks</st1:PersonName>; pgsql-odbc [at] postgresql.org 
Subject: RE: [ODBC] =
'Test'
connection button gives no message, just an 'OK' button... and =
connection
doesn't work<o:p></o:p>

</div>

<o:p> </o:p>

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.<o:p></o:p>

 <o:p></o:p>

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.<o:p></o:p>

 <o:p></o:p>

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.<o:p></o:p>

 <o:p></o:p>

Hope that =
helps,<o:p></o:p>

<st1:City w:st=3D"on"><st1:place w:st=3D"on">Regina</st1:place></st1:City><o:p></o:p>

 <o:p></o:p>

<o:p> </o:p>

<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'>

<hr size=3D2 width=3D"100%" align=3Dcenter tabIndex=3D-1>

</div>

From:</spa=
n>
pgsql-odbc-owner [at] postgresql.org [mailto:pgsql-odbc-owner [at] postgresql.org] =
On Behalf Of <st1:PersonName =
w:st=3D"on">Greg
Cocks</st1:PersonName> 
Sent: Tuesday, January =
15, 2008
12:04 PM 
To: =
pgsql-odbc [at] postgresql.org 
Subject: [ODBC] 'Test' =
connection
button gives no message, just an 'OK' button... and connection doesn't =
work<o:p></o:p>

Hello,<o:p></o:p>

<o:p> </o:p>

I am setting up a user for ODBC access to a =
PostgreSQL
server on the LAN, as I have done a few times =
before…<o:p></o:p>

<o:p> </o:p>

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…<o:p></o:p>

<o:p> </o:p>

All clients are running XP Pro, SP2 and all up to =
date on
other patches, etc<o:p></o:p>

<o:p> </o:p>

I opened up port 5432 and then turned the Windoze =
firewall
totally off just in case it was that – no luck =
there…<o:p></o:p>

<o:p> </o:p>

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…<o:p></o:p>

<o:p> </o:p>

Driver is v8.2.5…<o:p></o:p>

<o:p> </o:p>

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…<o:p></o:p>

<o:p> </o:p>

Very confused!<o:p></o:p>

<o:p> </o:p>

Any help much =
appreciated…<o:p></o:p>

<o:p> </o:p>

---------- 
Regards, 
GREG =
COCKS 
GIS =
Analyst V 
<a href=3D"blocked::mailto:gcocks [at] stoller.com"
title=3D"blocked::mailto:gcocks [at] stoller.com">gcocks
|at| stoller.com</a> 
S. M. Stoller Corp 
<st1:Street w:st=3D"on"><st1:address w:st=3D"on">105 Technology Drive, =
Suite 190</st1:address></st1:Street> 
<st1:place w:st=3D"on"><st1:City w:st=3D"on">Broomfield</st1:City>, =
<st1:State
w:st=3D"on">CO</st1:State> <st1:PostalCode =
w:st=3D"on">80021</st1:PostalCode></st1:place> 
<a href=3D"blocked::http://www.stoller.com/"
title=3D"blocked::http://www.stoller.com/">www.stoller.com</a> 
303-546-4300 
303-443-1408 fax 
303-546-4422 direct 
303-828-7576 cell<o:p></o:p>

<o:p> </o:p>

</div>

</body>

</html>

------_=_NextPart_001_01C8579C.C3A97AFA--

Greg Cocks [ Di, 15 Januar 2008 18:33 ] [ ID #1908213 ]

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

Greg Cocks wrote:
> 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=85
>
>
>
> Using the same settings, quadruple-checked, system DNS =96 but the 'Tes=
t'
> connection gives no message, just the =91!=92 icon and an 'OK' button o=
n
> just this one PC=85

Could you send me the Mylog output ?

regards,
Hiroshi Inoue

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Hiroshi Inoue [ Mi, 16 Januar 2008 04:22 ] [ ID #1909445 ]