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 ****t 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 <blocked::mailto:gcocks@[EMAIL PROTECTED]
>=20
S. M. Stoller Corp
105 Technology Drive, Suite 190
Broomfield, CO 80021
www.stoller.com <blocked::http://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
<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"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@[EMAIL PROTECTED]
Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Hello,<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>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></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>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></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>All clients are running XP Pro, SP2 and all up to =
date on
other patches, etc<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>I opened up ****t 5432 and then turned the Windoze =
firewall totally
off just in case it was that – no luck =
there…<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>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></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Driver is v8.2.5…<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>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></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Very confused!<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Any help much =
appreciated…<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=3D1 face=3D"Times New Roman"><span =
style=3D'font-size:7.5pt'>----------<br>
Regards,<br>
</span></font><strong><b><i><font size=3D2 face=3D"Times New =
Roman"><span
style=3D'font-size:10.0pt;font-style:italic'>GREG =
COCKS</span></font></i></b></strong><i><font
size=3D2><span style=3D'font-size:10.0pt;font-style:italic'><br>
</span></font></i><font size=3D1><span style=3D'font-size:7.5pt'>GIS =
Analyst V<br>
</span></font><a href=3D"blocked::mailto:gcocks@[EMAIL PROTECTED]
"
title=3D"blocked::mailto:gcocks@[EMAIL PROTECTED]
"><font size=3D1
title=3D"blocked::mailto:gcocks@[EMAIL PROTECTED]
"><span
title=3D"blocked::mailto:gcocks@[EMAIL PROTECTED]
"><span =
style=3D'font-size:7.5pt'>gcocks
|at| stoller.com</span></span></font></a><br>
<font size=3D1><span style=3D'font-size:7.5pt'>S. M. Stoller Corp<br>
<st1:Street w:st=3D"on"><st1:address w:st=3D"on">105 Technology Drive, =
Suite 190</st1:address></st1:Street><br>
<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><br>
</span></font><a href=3D"blocked::http://www.stoller.com/"
title=3D"blocked::http://www.stoller.com/"><font
size=3D1
title=3D"blocked::http://www.stoller.com/"><span
title=3D"blocked::http://www.stoller.com/"><span
=
style=3D'font-size:7.5pt'>www.stoller.com</span></span></font></a><br>
<font size=3D1><span style=3D'font-size:7.5pt'>303-546-4300<br>
303-443-1408 fax<br>
303-546-4422 direct<br>
303-828-7576 cell</span></font><o:p></o:p></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>
------_=_NextPart_001_01C85798.AF1D50EA--
|
