<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="country-region"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PostalCode"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="State"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="Street"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* 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;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I’m trying to connect to a SQLServer 2005 table
through OVF with little success…<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>My OVF file<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> <OGRVRTDataSource><o:p></o:p></span></font></p>
<p class=MsoNormal style='text-indent:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'> <OGRVRTLayer
name="banner_location"><o:p></o:p></span></font></p>
<p class=MsoNormal style='text-indent:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>
<SrcDataSource>ODBC:usr/pwd@ourdb,table_name</SrcDataSource><o:p></o:p></span></font></p>
<p class=MsoNormal style='text-indent:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>
<SRCLayer>table_name</SRCLayer><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>
<GeometryType>wkbPoint</GeometryType><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>
<GeometryField encoding="PointFromColumns" x="LONGITUDE"
y="LATITUDE"/><o:p></o:p></span></font></p>
<p class=MsoNormal style='text-indent:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>
</OGRVRTLayer><o:p></o:p></span></font></p>
<p class=MsoNormal style='text-indent:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'></OGRVRTDataSource><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Our mapfile just has a background (province) polygon layer
and this point layer. When I use shp2img there is no error reported but my
points aren’t on the image. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> shp2img
-m geoportal.map -o testing.png<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-indent:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>msDrawMap(): Layer 0 (Province),
0.172s<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-indent:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>msDrawMap(): Layer 1 (Major Roads),
0.046s<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-indent:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>msDrawMap(): Layer 2 (our_layer),
7.157s // the ovf layer<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-indent:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>msDrawMap(): Drawing Label Cache,
0.000s<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-indent:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>msDrawMap() total time: 7.375s <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I can use mapserv.exe to draw a map when the ovf layer is
turned off. When I attempt to connect through mapserver (mapscript, php) I get
the following error<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> [MapServer
Error]: msOGRFileOpen(): Open failed for OGR connection `..\..\common\data\ovf\our_layer.ovf'.<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-indent:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Unable to initialize ODBC connection
to DSN for usr/pwd@ourdb,table_name,<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-indent:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>[Microsoft][SQL Native Client]Named
Pipes Provider: Could not open a connection to SQL Server [1326].<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>When I use the ‘Sql Server’ odbc driver in the
connection I get the following for line 3 instead of the Named Pipes stuff<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> [Microsoft][ODBC
SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I’m using PHP 5.2.3 and </span></font>MapServer
version 4.10.2 <o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP
OUTPUT=PDF OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE
SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT
SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS
SUPPORTS=GEOS INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE
DEBUG=MSDEBUG<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Any suggestions are much appreciated, </span></font><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p><st1:PersonName w:st="on"><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Josh Hevenor</span></font></st1:PersonName><br>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Application
Developer<br>
</span></font><font size=1 face=Arial><span style='font-size:7.5pt;font-family:
Arial'>____________________________________________<br>
<st1:Street w:st="on"><st1:address w:st="on">5230 <st1:Street w:st="on">South
Service Road</st1:Street></st1:address></st1:Street><br>
<U1:CITY u2:insAuthor="Robert Murodch" u2:insDate="2005-12-19T11:22:00Z" u2:endInsAuthor="Robert Murodch" u2:endInsDate="2005-12-19T11:22:00Z" ns1:style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x" ns1:tabIndex="0"><U1:PLACE u2:insAuthor="Robert Murodch" u2:insDate="2005-12-19T11:22:00Z" u2:endInsAuthor="Robert Murodch" u2:endInsDate="2005-12-19T11:22:00Z" ns1:style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x" ns1:tabIndex="0"><st1:place
w:st="on"><st1:City w:st="on">Burlington</U1:PLACE></U1:CITY></st1:City>, <st1:State
w:st="on">Ontario</st1:State> <br>
<st1:PostalCode w:st="on">L7L 5K2</st1:PostalCode> <U1:COUNTRY-REGION u2:insAuthor="Robert Murodch" u2:insDate="2005-12-19T11:22:00Z" u2:endInsAuthor="Robert Murodch" u2:endInsDate="2005-12-19T11:22:00Z"><U1:PLACE u2:insAuthor="Robert Murodch" u2:insDate="2005-12-19T11:22:00Z" u2:endInsAuthor="Robert Murodch" u2:endInsDate="2005-12-19T11:22:00Z" ns1:style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x" ns1:tabIndex="0"><st1:country-region
w:st="on">Canada</U1:PLACE></U1:COUNTRY-REGION></st1:country-region></st1:place><br>
</span></font><font size=1 color=black face=Arial><span lang=EN-CA
style='font-size:7.5pt;font-family:Arial;color:black'><U1:ADDRESS u2:insAuthor="Robert Murodch" u2:insDate="2005-12-19T11:22:00Z" u2:endInsAuthor="Robert Murodch" u2:endInsDate="2005-12-19T11:22:00Z" ns1:style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x" ns1:tabIndex="0"><U1:COUNTRY-REGION u2:insAuthor="Robert Murodch" u2:insDate="2005-12-19T11:22:00Z" u2:endInsAuthor="Robert Murodch" u2:endInsDate="2005-12-19T11:22:00Z"><U1:PLACE u2:insAuthor="Robert Murodch" u2:insDate="2005-12-19T11:22:00Z" u2:endInsAuthor="Robert Murodch" u2:endInsDate="2005-12-19T11:22:00Z" ns1:style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x" ns1:tabIndex="0">Phone:
905-333-4544 ext. 19</span></font><font size=1 color=black face=Tahoma><span
lang=EN-CA style='font-size:7.5pt;font-family:Tahoma;color:black'><br>
</span></font><font size=1 color=black face=Arial><span lang=EN-CA
style='font-size:7.5pt;font-family:Arial;color:black'>Fax: 905-333-0455<br>
<U1:PLACE u2:insAuthor="Robert Murodch" u2:insDate="2005-12-19T11:22:00Z" u2:endInsAuthor="Robert Murodch" u2:endInsDate="2005-12-19T11:22:00Z" ns1:style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x" ns1:tabIndex="0">Cell:
905-320-7525</span></font></U1:PLACE><b><font size=2 face=Tahoma><span
lang=EN-CA style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'></U1:PLACE><br>
</span></font></b><strong><b><font size=1 face=Arial><span style='font-size:
7.5pt;font-family:Arial;font-weight:normal'></U1:COUNTRY-REGION></U1:ADDRESS><U1:ADDRESS u2:insAuthor="Robert Murodch" u2:insDate="2005-12-19T11:22:00Z" u2:endInsAuthor="Robert Murodch" u2:endInsDate="2005-12-19T11:22:00Z" ns1:style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x" ns1:tabIndex="0"><U1:COUNTRY-REGION u2:insAuthor="Robert Murodch" u2:insDate="2005-12-19T11:22:00Z" u2:endInsAuthor="Robert Murodch" u2:endInsDate="2005-12-19T11:22:00Z"><U1:PLACE u2:insAuthor="Robert Murodch" u2:insDate="2005-12-19T11:22:00Z" u2:endInsAuthor="Robert Murodch" u2:endInsDate="2005-12-19T11:22:00Z" ns1:style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x" ns1:tabIndex="0"></U1:PLACE></U1:COUNTRY-REGION></U1:ADDRESS>Email:
josh.hevenor@dpra.com</span></font></b></strong><b><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial;font-weight:bold'><br>
</span></font></b><font size=1 face=Arial><span style='font-size:7.5pt;
font-family:Arial'>Internet: http://www.dpra.com</span></font><b><span
style='font-weight:bold'><br>
</span></b><font size=2 face=Arial><span style='font-size:10.0pt;font-family:
Arial'><img width=150 height=43 id="_x0000_i1025"
src="cid:image001.jpg@01C7CF80.9B43E4F0" border=0><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
</span></font><strong><b><font size=2 color=silver face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:silver'>Attention:</span></font></b></strong><b><font
size=2 color=silver><span style='font-size:10.0pt;color:silver;font-weight:
bold'><br>
</span></font></b><font size=2 color=silver><span style='font-size:10.0pt;
color:silver'>Privileged/Confidential Information may be contained in this
message. Disclosure to any person other than the named recipient is
unauthorized. If you are not the intended recipient, please delete all copies
of this information and kindly notify the sender by reply email. Opinions,
conclusions and other information in this message that do not relate to the
official business of DPRA shall be understood as neither given nor endorsed by
it. DPRA and any of its subsidiaries reserve the right to monitor all e-mail
communications through its networks. Thank you.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>