David,<div><br></div><div>This might indeed be a bug in the OGR driver. Just file a ticket for that in the <a href="http://trac.osgeo.org/gdal/newticket">GDAL issue tracker</a>.</div><div><br></div><div>Best regards,</div>
<div><br></div><div>Tamas</div><div><br><br><br><div class="gmail_quote">2012/11/6 David Martin <span dir="ltr"><<a href="mailto:David@itbeyond.com.au" target="_blank">David@itbeyond.com.au</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-AU" link="blue" vlink="purple">
<div>
<p class="MsoNormal">Hi,<u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none">I have a geodata source on SQLServer 2008 and have been using for a number of years the
<span style="font-size:9.5pt;font-family:Consolas">msplugin_mssql2008.dll plugin. I now want to use some stored procedures in my SQL server to render the geo data to MapServer. So I have been working with the OGR driver however I have found what I think is
a problem when the SQL server is on a none standard TCP port as the comma in the server definition gets thrown away when rendering the layer using a map file via shp2img. I can use ogrinfo without problem but as soon as I carry the string to the OGR layer
in the .map file and run shp2img –all_debug 1 I see that the tcp port of my SQL server is removed and hence the connection fails.
<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><u></u> <u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas">So the working OGR syntax is:<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas">ogrinfo "MSSQL:uid=xxx;pwd=xxx;database=xxx;Integrated Security=false;server=MY_WEB-SqlServer.com,4670;tables=PointPlace_Waypoints(Position)" -summary<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas">INFO: Open of `MSSQL:uid=xxx;pwd=xxx;database=xxx;Integrated Security=false;server=MY_WEB-SqlServer.com,4670;tables=PointPlace_Waypoints(Position)'<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"> using driver `MSSQLSpatial' successful.<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas">1: PointPlace_Waypoints<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><u></u> <u></u></span></p>
<p class="MsoNormal">NOTE: The TCP Port is 4670 – this is the same as used in the mssql2008.dll plug in.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">When I use shp2img this is what I get:<u></u><u></u></p>
<p class="MsoNormal">shp2img -m latest.map -o test.png -all_debug 1<u></u><u></u></p>
<p class="MsoNormal">msDrawMap(): rendering using outputformat named png (AGG/PNG8).<u></u><u></u></p>
<p class="MsoNormal">msOGRFileOpen(MSSQL:uid=xxx;pwd=xxx;database=xxx;Integrated Security=false;server=<span style="font-size:9.5pt;font-family:Consolas">MY_WEB-SqlServer.com,4670</span>)...<u></u><u></u></p>
<p class="MsoNormal">OGROPen(MSSQL:uid=xxx;pwd=xxx;database=xxx;Integrated Security=false;server=<span style="font-size:9.5pt;font-family:Consolas"> MY_WEB-SqlServer.com</span>)<u></u><u></u></p>
<p class="MsoNormal">msOGRFileOpen(): OGR error. Open failed for OGR connection in layer `latest1'.<u></u><u></u></p>
<p class="MsoNormal">Unable to initialize connection to the server for MSSQL:uid=xxx;pwd=xxx;database=xxx;Integrated Security=false;server=<span style="font-size:9.5pt;font-family:Consolas">MY_WEB-SqlServer.com</span>,<u></u><u></u></p>
<p class="MsoNormal">[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">msDrawMap(): Image handling error. Failed to draw layer named 'latest1'.<u></u><u></u></p>
<p class="MsoNormal">msDrawMap(): Image handling error. Failed to draw layer named 'latest1'. <br><u></u><u></u></p>
<p class="MsoNormal">msOGRFileOpen(): OGR error. Open failed for OGR connection in layer `latest1'.<u></u><u></u></p>
<p class="MsoNormal">Unable to initialize connection to the server for MSSQL:uid=xxx;pwd=xxx;database=xxx;Integrated Security=false;server=<span style="font-size:9.5pt;font-family:Consolas">MY_WEB-SqlServer.com</span>,<u></u><u></u></p>
<p class="MsoNormal">[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">You will notice that two lines:<u></u><u></u></p>
<p class="MsoNormal">msOGRFileOpen(MSSQL:uid=xxx;pwd=xxx;database=xxx;Integrated Security=false;server=<span style="font-size:9.5pt;font-family:Consolas">MY_WEB-SqlServer.com,4670</span>)...<u></u><u></u></p>
<p class="MsoNormal">OGROPen(MSSQL:uid=xxx;pwd=xxx;database=xxx;Integrated Security=false;server=<span style="font-size:9.5pt;font-family:Consolas"> MY_WEB-SqlServer.com</span>)<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">The system is calling msOGRFileOpen with a ,4670 but the OGROPen has removed the comma and tcp port number hence my connection fails.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Is there a resolution to this or is there another way to execute stored procedures with MapServer layers?<span class="HOEnZb"><font color="#888888"><u></u><u></u></font></span></p><span class="HOEnZb"><font color="#888888">
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">David<u></u><u></u></p>
</font></span></div>
</div>
<br>_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
<br></blockquote></div><br></div>