<div dir="ltr"><div>Dear Tamaz,</div>
<div> I copied the query from the sqlserver profile and ran it in the query window, which displayed all the data corresponding to the polygon ID on which I clicked. </div>
<div>Will post the query and the results once I reach office tommorow morning. </div>
<div> </div>
<div>It seems like I m very close to the result, feels like I m missing some MAP configuration.</div>
<div> </div>
<div> </div>
<div> </div>
<div>Thnx a lot</div>
<div>Afroz<br><br></div>
<div class="gmail_quote">On Sun, Feb 28, 2010 at 9:22 PM, Tamas Szekeres [via OSGeo.org] <span dir="ltr"><<a href="http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4650244&i=0" target="_top" rel="nofollow">[hidden email]</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div class="im">How is the wkb result looking like when you execute the same query in a Query Analyzer session?<br><br></div>Best regards,<br><br>Tamas<br><br><br><br>
<div class="gmail_quote">2010/2/28 Afroz Kannancheri <span dir="ltr"><<a href="http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4649998&i=0" target="_blank" rel="nofollow" link="external">[hidden email]</a>></span><br>
<blockquote class="gmail_quote" style="PADDING-RIGHT: 1em; PADDING-LEFT: 1em; PADDING-BOTTOM: 0px; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: #cccccc 2px solid; PADDING-TOP: 0px">
<div>
<div></div>
<div class="h5"><br>Hi,<br> Tried the Tolerance parameter, now the previous error message is not<br>coming up anymore.<br> Checked the sqlserver profiler and now it recieves a valid query, but I<br>still get the following error on my page for the<br>
GetFeatureInfo results:<br><br>Layer 'region1'<br>Content-type: application/vnd.ogc.se_xml<br><?xml version='1.0' encoding="ISO-8859-1" standalone="no" ?><br><!DOCTYPE ServiceExceptionReport SYSTEM<br>
"<a href="http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd" target="_blank" rel="nofollow" link="external">http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd</a>"><br><ServiceExceptionReport version="1.1.1"><br>
<ServiceException><br></ServiceException><br></ServiceExceptionReport><br><br><br>I enabled DEBUG on the layer and it logs "msMSSQL2008LayerGetShapeRandom bad<br>shape: 1" in the log file.<br><br>
Please find part of my layer information for your reference<br><br> LAYER<br> NAME "region1"<br> CONNECTIONTYPE PLUGIN<br> PLUGIN "C:\Programs\ms4w\Apache\specialplugins\msplugin_mssql2008.dll"<br><br>
CONNECTION "server=192.168.254.34;uid=uid;pwd=pwd;database=map;Integrated<br>Security=false"<br><br> DATA "geom from region1"<br> TYPE POLYGON<br><br> DEBUG 0<br> STATUS ON<br> TOLERANCE 5<br> METADATA<br>
'wms_feature_info_mime_type' "text/html"<br> "ows_include_items" "all"<br> END<br> PROJECTION<br> "init=epsg:4326"<br> END<br><br><br><br>Thanks and regards<br>
Afroz<br><font color="#888888">--<br>View this message in context: <a href="http://n2.nabble.com/Getfeatureinfo-and-MSsql-2008-server-tp4631781p4648413.html" target="_blank" rel="nofollow" link="external">http://n2.nabble.com/Getfeatureinfo-and-MSsql-2008-server-tp4631781p4648413.html</a><br>
</font></div></div>
<div>
<div></div>
<div>
<div>
<div></div>
<div class="h5">Sent from the Mapserver - User mailing list archive at Nabble.com.<br>_______________________________________________<br>mapserver-users mailing list<br></div></div><a href="http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4649998&i=1" target="_blank" rel="nofollow" link="external">[hidden email]</a>
<div class="im"><br><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br></div></div></div></blockquote>
</div><br>
<div class="im"><br>_______________________________________________ <br>mapserver-users mailing list <br><a href="http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4649998&i=2" target="_blank" rel="nofollow" link="external">[hidden email]</a> <br>
</div>
<div class="im"><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
</blockquote></div><br></div>
<br><hr align="left" width="300">
View this message in context: <a href="http://n2.nabble.com/Getfeatureinfo-and-MSsql-2008-server-tp4631781p4650244.html">Re: Getfeatureinfo and MSsql 2008 server</a><br>
Sent from the <a href="http://n2.nabble.com/Mapserver-User-f1969211.html">Mapserver - User mailing list archive</a> at Nabble.com.<br>