[mapserver-users] Getfeatureinfo and MSsql 2008 server

[Paul james]

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 <afrozk at gmail.com> 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
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100225/1ab9561a/attachment.htm>