Hi ...<br><br>I have the same error here using Getfeature and Mssql2008... Works fine with Postgis connection ...<br><br>My last test was using Getfeature with a Point Layer... The message returned was :<br><br>Content-type: application/vnd.ogc.se_xml<br>
<br><?xml version='1.0' encoding="ISO-8859-1" standalone="no" ?><br><!DOCTYPE ServiceExceptionReport SYSTEM "<a href="http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd">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>No error reported using DEBUG mode...<br><br>The query generated was :<br>
<br>SELECT convert(varchar(max), oid),convert(varchar(max), id),the_geom.STAsBinary(),convert(varchar(20), oid) from viw_test WHERE the_geom.STIntersects(Geometry::STGeomFromText('POLYGON((-62.4340041752662 -11.1071026733531,-61.8187697837838 -11.1071026733531,-61.8187697837838 -10.4918682818707,-62.4340041752662 -10.4918682818707,-62.4340041752662 -11.1071026733531))',0)) = 1 <br>
<br>That query executed in Analyser return the right result:<br>0x010100000000917EFB3A104FC061A6ED5F598925C0<br><br>Using CGI NQuery also doesnt work, returning :<br>Content-type: text/html
<br><br>If you need more details, let me know...<br><br>Paul<br><br><br><br><div class="gmail_quote">On Tue, Mar 2, 2010 at 5:34 AM, Afroz Kannancheri <span dir="ltr"><<a href="mailto:afrozk@gmail.com">afrozk@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>
Dear Tamas,<br>
Heres the debug log obtained when i clicked on the polygon<br>
<br>
[Tue Mar 02 12:28:47 2010].113000 msMSSQL2008LayerOpen called datastatement:<br>
geom from region1 USING UNIQUE id USING SRID=4326<br>
[Tue Mar 02 12:28:47 2010].113000 MSMSSQL2008LayerOpen -- shared connection<br>
not available.<br>
[Tue Mar 02 12:28:47 2010].957000<br>
msConnPoolRegister(region1,server=3.254.254.34;uid=sa;pwd=pwd;database=map;Integrated<br>
Security=false,01E39FC0)<br>
[Tue Mar 02 12:28:47 2010].957000 msMSSQL2008LayerParseData: unique column =<br>
id, srid='4326', geom_column_name = geom, table_name=region1<br>
[Tue Mar 02 12:28:47 2010].957000 msMSSQL2008LayerFreeItemInfo called<br>
[Tue Mar 02 12:28:47 2010].957000 in msMSSQL2008LayerGetItems (find column<br>
names)<br>
[Tue Mar 02 12:28:48 2010].113000 msMSSQL2008LayerInitItemInfo called<br>
[Tue Mar 02 12:28:48 2010].113000 msMSSQL2008LayerInitItemInfo called<br>
[Tue Mar 02 12:28:48 2010].113000 msMSSQL2008LayerWhichShapes called<br>
[Tue Mar 02 12:28:48 2010].113000 query_string_temp:SELECT<br>
<div class="im">convert(varchar(max), ID),convert(varchar(max), name),convert(varchar(max),<br>
flag1),convert(varchar(max), flag2),convert(varchar(max),<br>
flag3),geom.STAsBinary(),convert(varchar(20), id) from region1 WHERE<br>
geom.STIntersects(Geometry::STGeomFromText('POLYGON((55.4843749962207<br>
-4.59960928778372,56.5390624973545 -4.59960928778372,56.5390624973545<br>
-3.54492178664993,55.4843749962207 -3.54492178664993,55.4843749962207<br>
-4.59960928778372))',4326)) = 1<br>
</div>[Tue Mar 02 12:28:48 2010].394000 msMSSQL2008LayerClose datastatement: geom<br>
from region1 USING UNIQUE id USING SRID=4326<br>
[Tue Mar 02 12:28:48 2010].394000<br>
msConnPoolRelease(region1,server=3.254.254.34;uid=sa;pwd=pwd;database=map;Integrated<br>
Security=false,01E39FC0)<br>
[Tue Mar 02 12:28:48 2010].394000<br>
msConnPoolClose(server=3.254.254.34;uid=sa;pwd=pwd;database=map;Integrated<br>
Security=false,01E39FC0)<br>
[Tue Mar 02 12:28:48 2010].410000 freeLayer(): freeing layer at 01E15180.<br>
<br>
Thnx<br>
Afroz<br>
<font color="#888888">--<br>
View this message in context: <a href="http://n2.nabble.com/Getfeatureinfo-and-MSsql-2008-server-tp4631781p4659685.html" target="_blank">http://n2.nabble.com/Getfeatureinfo-and-MSsql-2008-server-tp4631781p4659685.html</a><br>
</font><div class="im">Sent from the Mapserver - User mailing list archive at Nabble.com.<br>
_______________________________________________<br>
mapserver-users mailing list<br>
</div><div><div></div><div class="h5"><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>
</div></div></blockquote></div><br>