Now Itīs working Tamas...<br>Iīll test more later...<br><br>Thanks !<br><br>Paul<br><br><div class="gmail_quote">On Sat, Mar 6, 2010 at 6:56 PM, Tamas Szekeres <span dir="ltr"><<a href="mailto:szekerest@gmail.com">szekerest@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;">I've just applied a couple of fixes in both the development and the stable branches with regards to the MSSQL2008 driver.<br>
<br>The details of the fixes have been added to.<br><a href="http://trac.osgeo.org/mapserver/ticket/3058" target="_blank">http://trac.osgeo.org/mapserver/ticket/3058</a><br>
<br>Ready to use binaries containing the recent fixes are available at:<div class="im"><br><a href="http://vbkto.dyndns.org/sdk/" target="_blank">http://vbkto.dyndns.org/sdk/</a><br><br></div>Any feedback and further testing efforts would be helpful, before we issue the next stable release 5.6.2 (hopefully in the next week)<br>
<br>Best regards,<br><br>Tamas<br><br><br><br><div class="gmail_quote">2010/3/3 Paul james <span dir="ltr"><<a href="mailto:pauljame@gmail.com" target="_blank">pauljame@gmail.com</a>></span><div><div></div><div class="h5">
<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br><div class="gmail_quote">Hi <br>Iīm sending a point table that Iīm using to test...<div><div></div><div><br><br>Layer definition :<br>LAYER<br> NAME Test<br> METADATA<br> "wms_title" "Test" ##required<div>
<br>
"wms_feature_info_mime_type" "text/html" <br></div> END <br> TYPE POINT<br> STATUS ON<br> INCLUDE "Connection.map" <br> DATA "the_geom from tblGeo_Porto USING UNIQUE CodigoPorto USING SRID=0"<br>
<br> TOLERANCE 14 <br> TEMPLATE "query.html" <br> <br> CLASS<br> TEMPLATE "dummy"<br> NAME "Test"<br> STYLE<br> SYMBOL 'test_15'<br>
COLOR 0 0 0<br> ANTIALIAS TRUE<br> END<br> END <br> END<br><br>Nquery CGI call :<br><a href="http://localhost/cgi-bin-last/mapserv.exe?map=Map.map&mode=nquery&LAYERS=Test&mapext=-54.463422851562+-28.5204328125+-54.155805664062+-28.267747265625&imgext=-54.463422851562+-28.5204328125+-54.155805664062+-28.267747265625&map_size=1221+670&imgxy=1221+670&imgbox=0+0+1221+670" target="_blank">http://localhost/cgi-bin-last/mapserv.exe?map=Map.map&mode=nquery&LAYERS=Test&mapext=-54.463422851562+-28.5204328125+-54.155805664062+-28.267747265625&imgext=-54.463422851562+-28.5204328125+-54.155805664062+-28.267747265625&map_size=1221+670&imgxy=1221+670&imgbox=0+0+1221+670</a><br>
<br>I got : <br>Content-type: text/html
<br><br>Using Postgis (same code) works fine...<br><br>If you need, I can send the GetFeatureInfo code as well... But I think itīs the same "bug" ...<br><br>The db data is attached...<br><font color="#888888"><br>
Paul</font><div><div></div><div><br><br><br><br>
<div class="gmail_quote">On Tue, Mar 2, 2010 at 8:01 PM, Tamas Szekeres <span dir="ltr"><<a href="mailto:szekerest@gmail.com" target="_blank">szekerest@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;">
Paul<br><br>It would be helpful to have some test data to reproduce your problem. <br><br>In the meantime I've found an issue with regards of the query handling in the sql2008 driver and working on a fix right now, however I'm not sure if it is related to the problem of yours. <br>
<br>Best regards,<br><br>Tamas<br><br><br><div class="gmail_quote">2010/3/2 Paul james <span dir="ltr"><<a href="mailto:pauljame@gmail.com" target="_blank">pauljame@gmail.com</a>></span><div><div></div><div>
<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
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 :<div><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" target="_blank">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></div>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><font color="#888888"><br>Paul</font><div><div></div><div><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" target="_blank">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>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>Sent from the Mapserver - User mailing list archive at Nabble.com.<br>
_______________________________________________<br>
mapserver-users mailing list<br>
</div><div><div></div><div><a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">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>
</div></div></blockquote></div></div></div><br>
</blockquote></div><br>
</div></div></div></div></div><br>
<br>_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">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></div></div><br>
</blockquote></div><br>