[mapserver-users] Getfeatureinfo and MSsql 2008 server

[Tamas Szekeres]

Paul,

I don't see any compelling reason why these use cases wouldn't work. Could
you provide a sample data/mapfile/example URL to reproduce this?

Best regards,

Tamas



2010/2/25 Paul james <pauljame at gmail.com>

> 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
>>
>
>
> _______________________________________________
> 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/20100226/7d12eb30/attachment.htm>