[MAPSERVER-USERS] ms sql 2008 spatial - still problems???

[Tamas Szekeres]

Can you execute the same SQL statement in the SQL Sever 2008 Management Studio?
Could you post a sample code to reproduce the problem?

Best regards,

Tamas

2008/10/10 BrainDrain <paulborodaev at gmail.com>:
>
> With new (from ms4w 2.3) plugin:
> mapserv.exe draws map but in mapscript c#:
> Access violation while map.draw() (sometimes, when panning, not every time)
> or for ex. error message:
> msDrawMap(): Image handling error. Failed to draw layer named
> 'construct1'.;msMSSQL2008LayerGetShape(): Query error. Error executing
> MSSQL2008 SQL statement: SELECT GEOM.STAsBinary(),convert(varchar(20), id)
> from dbo.Construct WHERE
> GEOM.STIntersects(Geometry::STGeomFromText('POLYGON((...coords...))',0)) = 1
> -3
>
> &
> Access violation on any layer query (spatial/attribute) operation
> or for ex. (query bu point)
> Query error. Error executing MSSQL2008 SQL statement:
> SELECT GEOM.STAsBinary(),convert(varchar(20), id) from dbo.Construct WHERE
> GEOM.STIntersects(Geometry::STGeomFromText('POLYGON((...coords...))',0)) = 1
> -3
>
> How should I work with it?
>
> --
> View this message in context: http://www.nabble.com/ms-sql-2008-spatial---still-problems----tp19454300p19916057.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
>