Dear Tamaz, 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. Will post the query and the results once I reach office tommorow morning.
It seems like I m very close to the result, feels like I m missing some MAP configuration. Thnx a lot Afroz On Sun, Feb 28, 2010 at 9:22 PM, Tamas Szekeres [via OSGeo.org] < [email protected]<ml-node%[email protected]> > wrote: > How is the wkb result looking like when you execute the same query in a > Query Analyzer session? > > Best regards, > > Tamas > > > > 2010/2/28 Afroz Kannancheri <[hidden > email]<http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4649998&i=0> > > > >> >> Hi, >> Tried the Tolerance parameter, now the previous error message is not >> coming up anymore. >> Checked the sqlserver profiler and now it recieves a valid query, but I >> still get the following error on my page for the >> GetFeatureInfo results: >> >> Layer 'region1' >> Content-type: application/vnd.ogc.se_xml >> <?xml version='1.0' encoding="ISO-8859-1" standalone="no" ?> >> <!DOCTYPE ServiceExceptionReport SYSTEM >> "http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd";> >> <ServiceExceptionReport version="1.1.1"> >> <ServiceException> >> </ServiceException> >> </ServiceExceptionReport> >> >> >> I enabled DEBUG on the layer and it logs "msMSSQL2008LayerGetShapeRandom >> bad >> shape: 1" in the log file. >> >> Please find part of my layer information for your reference >> >> LAYER >> NAME "region1" >> CONNECTIONTYPE PLUGIN >> PLUGIN "C:\Programs\ms4w\Apache\specialplugins\msplugin_mssql2008.dll" >> >> CONNECTION "server=192.168.254.34;uid=uid;pwd=pwd;database=map;Integrated >> Security=false" >> >> DATA "geom from region1" >> TYPE POLYGON >> >> DEBUG 0 >> STATUS ON >> TOLERANCE 5 >> METADATA >> 'wms_feature_info_mime_type' "text/html" >> "ows_include_items" "all" >> END >> PROJECTION >> "init=epsg:4326" >> END >> >> >> >> Thanks and regards >> Afroz >> -- >> View this message in context: >> http://n2.nabble.com/Getfeatureinfo-and-MSsql-2008-server-tp4631781p4648413.html >> Sent from the Mapserver - User mailing list archive at Nabble.com. >> _______________________________________________ >> mapserver-users mailing list >> [hidden >> email]<http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4649998&i=1> >> >> http://lists.osgeo.org/mailman/listinfo/mapserver-users >> > > > _______________________________________________ > mapserver-users mailing list > [hidden > email]<http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4649998&i=2> > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > > ------------------------------ > View message @ > http://n2.nabble.com/Getfeatureinfo-and-MSsql-2008-server-tp4631781p4649998.html > To unsubscribe from Re: Getfeatureinfo and MSsql 2008 server, click here< > (link removed) ==>. > > > -- View this message in context: http://n2.nabble.com/Getfeatureinfo-and-MSsql-2008-server-tp4631781p4650244.html Sent from the Mapserver - User mailing list archive at Nabble.com.
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
