[mapserver-users] Getfeatureinfo and MSsql 2008 server

[James Perrins]

.queryByPoint works OK for me from C# mapscript




On Thu, Feb 25, 2010 at 11:51 AM, Paul james <pauljame at gmail.com> wrote:
> 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
>
>



-- 
Dr James Perrins
exeGesIS SDM Ltd
Great House Barn
New Street, Talgarth
Powys LD3 0AH.
Direct Line: 01646 686650
Tel: 01874 711145
Fax: 01874 711156
Email: JamesP at esdm.co.uk

This E-mail and any files transmitted with it are private and intended
solely for the use of the individual or entity to whom they are
addressed. If you are not the intended recipient, the E-mail and any
files have been transmitted to you in error and any copying,
distribution or other use of the information contained in them is
strictly prohibited.

Nothing in this E-mail message amounts to a contractual or other legal
commitment on the part of exeGesIS SDM Ltd unless confirmed by a
signed communication.

exeGesIS SDM Ltd will make every effort to keep its network free of
viruses. However, the recipient of this message will need to scan this
message, and any attachments, for viruses, as exeGesIS SDM Ltd can
take no responsibility for any computer virus that might be
transferred by this e-mail.