The Mssql2008 driver is incomplete... GetFeatureInfo, Nquery, Query doesnt work at all...
http://trac.osgeo.org/mapserver/ticket/3058 Paul On Thu, Feb 25, 2010 at 7:57 AM, Afroz Kannancheri <[email protected]> wrote: > > Hi All, > > I have a layer drawn from the shape information stored in MSSQL 2008 > server. > The layer has around 300 polygons which are drawn perfectly on a world base > map. > When i try to get the details for each polygon using the Getfeatureinfo > during the click event, i get the following error from MSSQL 2008 server. > > msMSSQL2008LayerGetShape(): Query error. Error executing MSSQL2008 SQL > statement: SELECT convert(varchar(max), numb1),convert(varchar(max), > poprate),geom.STAsBinary(),convert(varchar(20), ID) from table1 WHERE > geom.STIntersects(Geometry::STGeomFromText('POLYGON((-16.4101563310658 > 17.724609875,-16.4101563310658 17.724609875,-16.4101563310658 > 17.724609875,-16.4101563310658 17.724609875,-16.4101563310658 > 17.724609875))',0)) = 1 -[Microsoft][ODBC SQL Server Driver][SQL Server]A > .NET Framework error occurred during execution of user defined routine or > aggregate 'geometry': System.FormatException: 24118: The Polygon input is > not valid because the exterior ring does not have enough points. Each ring > of a polygon must contain at least three distinct points. > System.FormatException: at > Microsoft.SqlServer.Types.GeometryDataBuilder.EndFigure() at > > Microsoft.SqlServer.Types.OpenGisWktReader.ParseLineStringText(FigureAttributes > attributes) at > Microsoft.SqlServer.Types.OpenGisWktReader.ParsePolygonText() > at Microsoft.SqlServer.Types.OpenGisWktReader.ParsePolygonTaggedText() at > Microsoft.SqlServer.Types.OpenGisWktReader.ParseGeometryTaggedText() at > Microsoft.SqlServer.Types.OpenGisWktReader.ReadGeometry() at > Microsoft.SqlServer.Types.SqlGeometry.STGeomFromText(SqlChars > geometryTaggedText, Int32 srid) > > > Has anyone faced such an issue before. > > > Thanks and regards > AFroz Kannancheri > -- > View this message in context: > http://n2.nabble.com/Getfeatureinfo-and-MSsql-2008-server-tp4631781p4631781.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
