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 <[email protected]> > > 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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users >
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
