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
