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@[EMAIL PROTECTED]
On Behalf Of Greg Cocks=0D=0ASent: Tuesday, January 15, 2008 12:04
=
PM=0D=0ATo: pgsql-odbc@[EMAIL PROTECTED]
[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 ****t 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@[EMAIL PROTECTED]
> =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:smarttags"></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:smartta=
gs"></o:SmartTagType><o:SmartTagType =0D=0Aname=3D"address"
=0D=0Anamespace=
uri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><!--[if=
!mso]>=0D=0A<STYLE>st1\:* {=0D=0A BEHAVIOR:
url(#default#ieooui)=0D=0A}=0D=
=0A</STYLE>=0D=0A<![endif]-->=0D=0A<STYLE>@[EMAIL PROTECTED]
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><SPAN
class=3D255541517-1=
5012008><FONT face=3DArial =0D=0Acolor=3D#0000ff size=3D2>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</FONT></SPAN></DIV>=0D=0A<DIV dir=3Dltr align=3Dleft><SPAN
c=
lass=3D255541517-15012008><FONT face=3DArial =0D=0Acolor=3D#0000ff
size=3D2=
></FONT></SPAN> </DIV>=0D=0A<DIV dir=3Dltr align=3Dleft><SPAN
class=3D=
255541517-15012008><FONT face=3DArial =0D=0Acolor=3D#0000ff size=3D2>Did
</=
FONT></SPAN><SPAN class=3D255541517-15012008><FONT =0D=0Aface=3DArial
color=
=3D#0000ff size=3D2>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></SPAN></DIV>=0D=0A<DIV dir=3Dltr align=3Dleft><SPAN
class=3D255541517-1=
5012008><FONT face=3DArial =0D=0Acolor=3D#0000ff
size=3D2></FONT></SPAN>&nb=
sp;</DIV>=0D=0A<DIV dir=3Dltr align=3Dleft><SPAN
class=3D255541517-15012008=
><FONT face=3DArial =0D=0Acolor=3D#0000ff size=3D2>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</FONT></SPAN></DIV>=0D=0A<DIV dir=3Dltr
align=3Dle=
ft><SPAN class=3D255541517-15012008><FONT face=3DArial
=0D=0Acolor=3D#0000f=
f size=3D2></FONT></SPAN> </DIV>=0D=0A<DIV dir=3Dltr
align=3Dleft><SPA=
N class=3D255541517-15012008><FONT face=3DArial =0D=0Acolor=3D#0000ff
size=
=3D2>Hope that helps,</FONT></SPAN></DIV>=0D=0A<DIV dir=3Dltr
align=3Dleft>=
<SPAN class=3D255541517-15012008><FONT face=3DArial =0D=0Acolor=3D#0000ff
s=
ize=3D2>Regina</FONT></SPAN></DIV>=0D=0A<DIV dir=3Dltr align=3Dleft><SPAN
c=
lass=3D255541517-15012008><FONT face=3DArial =0D=0Acolor=3D#0000ff
size=3D2=
></FONT></SPAN> </DIV><BR>=0D=0A<DIV class=3DOutlookMessageHeader
lang=
=3Den-us dir=3Dltr align=3Dleft>=0D=0A<HR tabIndex=3D-1>=0D=0A<FONT
face=3D=
Tahoma size=3D2><B>From:</B> pgsql-odbc-owner@[EMAIL PROTECTED]
<B>On Behalf Of </B>Greg
=0D=0ACocks<B=
R><B>Sent:</B> Tuesday, January 15, 2008 12:04 PM<BR><B>To:</B>
=0D=0Apgsql=
-odbc@[EMAIL PROTECTED]
><B>Subject:</B> [ODBC] 'Test' connection button
=
=0D=0Agives no message, just an 'OK' button=2E=2E=2E and connection
doesn't=
=0D=0Awork<BR></FONT><BR></DIV>=0D=0A<DIV></DIV>=0D=0A<DIV
class=3DSection=
1>=0D=0A<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN
=0D=0Astyle=
=3D"FONT-SIZE: 10pt; FONT-FAMILY:
Arial">Hello,<o:p></o:p></SPAN></FONT></P=
>=0D=0A<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN =0D=0Astyle=
=3D"FONT-SIZE: 10pt; FONT-FAMILY:
Arial"><o:p> </o:p></SPAN></FONT></P=
>=0D=0A<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN =0D=0Astyle=
=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">I 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></SPAN></FONT></P>=0D=0A<P
class=3DMsoNormal>=
<FONT face=3DArial size=3D2><SPAN =0D=0Astyle=3D"FONT-SIZE: 10pt;
FONT-FAMI=
LY: Arial"><o:p> </o:p></SPAN></FONT></P>=0D=0A<P
class=3DMsoNormal><F=
ONT face=3DArial size=3D2><SPAN =0D=0Astyle=3D"FONT-SIZE: 10pt;
FONT-FAMILY=
: Arial">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></FONT></P>=0D=0A<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN
=
=0D=0Astyle=3D"FONT-SIZE: 10pt; FONT-FAMILY:
Arial"><o:p> </o:p></SPAN=
></FONT></P>=0D=0A<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN =
=0D=0Astyle=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">All clients are
running=
XP Pro, SP2 =0D=0Aand all up to date on other patches,
etc<o:p></o:p></SPA=
N></FONT></P>=0D=0A<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN
=
=0D=0Astyle=3D"FONT-SIZE: 10pt; FONT-FAMILY:
Arial"><o:p> </o:p></SPAN=
></FONT></P>=0D=0A<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN =
=0D=0Astyle=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">I opened up ****t 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></SPAN></FONT></P>=0D=0A<P=
class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN
=0D=0Astyle=3D"FONT-SI=
ZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>=0D=0A<P
c=
lass=3DMsoNormal><FONT face=3DArial size=3D2><SPAN
=0D=0Astyle=3D"FONT-SIZE=
: 10pt; FONT-FAMILY: Arial">This 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></SPAN></FONT>=
</P>=0D=0A<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN
=0D=0Astyl=
e=3D"FONT-SIZE: 10pt; FONT-FAMILY:
Arial"><o:p> </o:p></SPAN></FONT></=
P>=0D=0A<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN
=0D=0Astyle=
=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Driver is
=0D=0Av8=2E2=2E5…<=
o:p></o:p></SPAN></FONT></P>=0D=0A<P class=3DMsoNormal><FONT face=3DArial
s=
ize=3D2><SPAN =0D=0Astyle=3D"FONT-SIZE: 10pt; FONT-FAMILY:
Arial"><o:p>&nbs=
p;</o:p></SPAN></FONT></P>=0D=0A<P class=3DMsoNormal><FONT face=3DArial
siz=
e=3D2><SPAN =0D=0Astyle=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">And 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></SPAN></FONT></P>=0D=0A<P class=3DMsoNormal><FONT
face=3DAria=
l size=3D2><SPAN =0D=0Astyle=3D"FONT-SIZE: 10pt; FONT-FAMILY:
Arial"><o:p>&=
nbsp;</o:p></SPAN></FONT></P>=0D=0A<P class=3DMsoNormal><FONT face=3DArial
=
size=3D2><SPAN =0D=0Astyle=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Very
=0D=
=0Aconfused!<o:p></o:p></SPAN></FONT></P>=0D=0A<P class=3DMsoNormal><FONT
f=
ace=3DArial size=3D2><SPAN =0D=0Astyle=3D"FONT-SIZE: 10pt; FONT-FAMILY:
Ari=
al"><o:p> </o:p></SPAN></FONT></P>=0D=0A<P class=3DMsoNormal><FONT
fac=
e=3DArial size=3D2><SPAN =0D=0Astyle=3D"FONT-SIZE: 10pt; FONT-FAMILY:
Arial=
">Any help much
=0D=0Aappreciated…<o:p></o:p></SPAN></FONT></P>=0D=0A=
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN
=0D=0Astyle=3D"FONT-=
SIZE: 10pt; FONT-FAMILY:
Arial"><o:p> </o:p></SPAN></FONT></P>=0D=0A<P=
class=3DMsoNormal =0D=0Astyle=3D"mso-margin-top-alt: auto;
mso-margin-bott=
om-alt: auto"><FONT =0D=0Aface=3D"Times New Roman" size=3D1><SPAN
=0D=0Asty=
le=3D"FONT-SIZE:
7=2E5pt">----------<BR>Regards,<BR></SPAN></FONT><STRONG><=
B><I><FONT =0D=0Aface=3D"Times New Roman" size=3D2><SPAN
=0D=0Astyle=3D"FON=
T-SIZE: 10pt; FONT-STYLE: italic">GREG
=0D=0ACOCKS</SPAN></FONT></I></B></S=
TRONG><I><FONT size=3D2><SPAN =0D=0Astyle=3D"FONT-SIZE: 10pt; FONT-STYLE:
i=
talic"><BR></SPAN></FONT></I><FONT =0D=0Asize=3D1><SPAN
style=3D"FONT-SIZE:=
7=2E5pt">GIS Analyst V<BR></SPAN></FONT><A
=0D=0Atitle=3Dblocked::mailto:g=
cocks@[EMAIL PROTECTED]
"blocked::mailto:gcocks@[EMAIL PROTECTED]
"><FO=
NT =0D=0Atitle=3Dblocked::mailto:gcocks@[EMAIL PROTECTED]
size=3D1><SPAN
=0D=0A=
title=3Dblocked::mailto:gcocks@[EMAIL PROTECTED]
><SPAN style=3D"FONT-SIZE:
7=2E=
5pt">gcocks =0D=0A|at| stoller=2Ecom</SPAN></SPAN></FONT></A><BR><FONT
size=
=3D1><SPAN =0D=0Astyle=3D"FONT-SIZE: 7=2E5pt">S=2E M=2E Stoller
Corp<BR><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><BR><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>=
<BR></SPAN></FONT><A =0D=0Atitle=3Dblocked::http://www=2Estoller=2Ecom/
=0D=
=0Ahref=3D"blocked::http://www=2Estoller=2Ecom/"><FONT
=0D=0Atitle=3Dblocke=
d::http://www=2Estoller=2Ecom/
size=3D1><SPAN
=0D=0Atitle=3Dblocked::http:/=
/www=2Estoller=2Ecom/><SPAN =0D=0Astyle=3D"FONT-SIZE:
7=2E5pt">www=2Estolle=
r=2Ecom</SPAN></SPAN></FONT></A><BR><FONT =0D=0Asize=3D1><SPAN
style=3D"FON=
T-SIZE: 7=2E5pt">303-546-4300<BR>303-443-1408 =0D=0Afax<BR>303-546-4422
dir=
ect<BR>303-828-7576 cell</SPAN></FONT><o:p></o:p></P>=0D=0A<P
class=3DMsoNo=
rmal><FONT face=3D"Times New Roman" size=3D3><SPAN
=0D=0Astyle=3D"FONT-SIZE=
:
12pt"><o:p> </o:p></SPAN></FONT></P></DIV></BODY></HTML>=0D=0A=0D=0A
------_=_NextPart_001_01C8579C.17E38571--
|
