I've just applied a couple of fixes in both the development and the stable branches with regards to the MSSQL2008 driver.
The details of the fixes have been added to. http://trac.osgeo.org/mapserver/ticket/3058 Ready to use binaries containing the recent fixes are available at: http://vbkto.dyndns.org/sdk/ Any feedback and further testing efforts would be helpful, before we issue the next stable release 5.6.2 (hopefully in the next week) Best regards, Tamas 2010/3/3 Paul james <[email protected]> > > Hi > I´m sending a point table that I´m using to test... > > > Layer definition : > LAYER > NAME Test > METADATA > "wms_title" "Test" ##required > > "wms_feature_info_mime_type" "text/html" > END > TYPE POINT > STATUS ON > INCLUDE "Connection.map" > DATA "the_geom from tblGeo_Porto USING UNIQUE CodigoPorto USING > SRID=0" > > TOLERANCE 14 > TEMPLATE "query.html" > > CLASS > TEMPLATE "dummy" > NAME "Test" > STYLE > SYMBOL 'test_15' > COLOR 0 0 0 > ANTIALIAS TRUE > END > END > END > > Nquery CGI call : > > 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 > > I got : > Content-type: text/html > > Using Postgis (same code) works fine... > > If you need, I can send the GetFeatureInfo code as well... But I think it´s > the same "bug" ... > > The db data is attached... > > Paul > > > > > On Tue, Mar 2, 2010 at 8:01 PM, Tamas Szekeres <[email protected]>wrote: > >> Paul >> >> It would be helpful to have some test data to reproduce your problem. >> >> 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. >> >> Best regards, >> >> Tamas >> >> >> 2010/3/2 Paul james <[email protected]> >> >> Hi ... >>> >>> I have the same error here using Getfeature and Mssql2008... Works fine >>> with Postgis connection ... >>> >>> My last test was using Getfeature with a Point Layer... The message >>> returned was : >>> >>> >>> 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> >>> >>> No error reported using DEBUG mode... >>> >>> The query generated was : >>> >>> 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 >>> >>> That query executed in Analyser return the right result: >>> 0x010100000000917EFB3A104FC061A6ED5F598925C0 >>> >>> Using CGI NQuery also doesnt work, returning : >>> Content-type: text/html >>> >>> If you need more details, let me know... >>> >>> Paul >>> >>> >>> >>> >>> On Tue, Mar 2, 2010 at 5:34 AM, Afroz Kannancheri <[email protected]>wrote: >>> >>>> >>>> Dear Tamas, >>>> Heres the debug log obtained when i clicked on the polygon >>>> >>>> [Tue Mar 02 12:28:47 2010].113000 msMSSQL2008LayerOpen called >>>> datastatement: >>>> geom from region1 USING UNIQUE id USING SRID=4326 >>>> [Tue Mar 02 12:28:47 2010].113000 MSMSSQL2008LayerOpen -- shared >>>> connection >>>> not available. >>>> [Tue Mar 02 12:28:47 2010].957000 >>>> >>>> msConnPoolRegister(region1,server=3.254.254.34;uid=sa;pwd=pwd;database=map;Integrated >>>> Security=false,01E39FC0) >>>> [Tue Mar 02 12:28:47 2010].957000 msMSSQL2008LayerParseData: unique >>>> column = >>>> id, srid='4326', geom_column_name = geom, table_name=region1 >>>> [Tue Mar 02 12:28:47 2010].957000 msMSSQL2008LayerFreeItemInfo called >>>> [Tue Mar 02 12:28:47 2010].957000 in msMSSQL2008LayerGetItems (find >>>> column >>>> names) >>>> [Tue Mar 02 12:28:48 2010].113000 msMSSQL2008LayerInitItemInfo called >>>> [Tue Mar 02 12:28:48 2010].113000 msMSSQL2008LayerInitItemInfo called >>>> [Tue Mar 02 12:28:48 2010].113000 msMSSQL2008LayerWhichShapes called >>>> [Tue Mar 02 12:28:48 2010].113000 query_string_temp:SELECT >>>> convert(varchar(max), ID),convert(varchar(max), >>>> name),convert(varchar(max), >>>> flag1),convert(varchar(max), flag2),convert(varchar(max), >>>> flag3),geom.STAsBinary(),convert(varchar(20), id) from region1 WHERE >>>> geom.STIntersects(Geometry::STGeomFromText('POLYGON((55.4843749962207 >>>> -4.59960928778372,56.5390624973545 -4.59960928778372,56.5390624973545 >>>> -3.54492178664993,55.4843749962207 -3.54492178664993,55.4843749962207 >>>> -4.59960928778372))',4326)) = 1 >>>> [Tue Mar 02 12:28:48 2010].394000 msMSSQL2008LayerClose datastatement: >>>> geom >>>> from region1 USING UNIQUE id USING SRID=4326 >>>> [Tue Mar 02 12:28:48 2010].394000 >>>> >>>> msConnPoolRelease(region1,server=3.254.254.34;uid=sa;pwd=pwd;database=map;Integrated >>>> Security=false,01E39FC0) >>>> [Tue Mar 02 12:28:48 2010].394000 >>>> >>>> msConnPoolClose(server=3.254.254.34;uid=sa;pwd=pwd;database=map;Integrated >>>> Security=false,01E39FC0) >>>> [Tue Mar 02 12:28:48 2010].410000 freeLayer(): freeing layer at >>>> 01E15180. >>>> >>>> Thnx >>>> Afroz >>>> -- >>>> View this message in context: >>>> http://n2.nabble.com/Getfeatureinfo-and-MSsql-2008-server-tp4631781p4659685.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 > >
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
