[mapguide-users] MSSqlServer Spatial problem

[Dave Wilson]

What coordinate system is your data in? Apparently SQL Server has 2 geometry types, Geometry and Geography. Geography is used for Lat Long based data. I haven't worked with inserts and the new provider so I don't know if there is anything special about it. Are you inserting features one by one? Attaching your code might help.

Regards,
Dave

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of zolinko
Sent: Wednesday, June 24, 2009 7:27 AM
To: mapguide-users at lists.osgeo.org
Subject: [mapguide-users] MSSqlServer Spatial problem


Hi All,

I have a problem inserting geometry into MSSqlServer2008 with the spatial
provider through Mapguide Enterprise 2010.
The whole process is completely working with the NON spatial fdo provider
(where the geometry fields in the db are typed as 'image')
But when I change the provider and define the geometry fields 'Geometry', it
doesn't work.

It doesn't throw any exception, (not seen anything in db log, mapguide log
or client log), and it is not hangs.
simply the mapguide process takes 100% cpu time for even an hour (or more,
then I restrarted it)

I use the MgAgfReaderWriter, to write the geometry to the GeometryProperty
and than
use the featureService.UpdateFeature method.

If anyone has some experience (or code example) on how to use mssql spatial
from mapguide,
please, let me know.

Any idea will be appreciated.
TIA
zolinko
-- 
View this message in context: http://n2.nabble.com/MSSqlServer-Spatial-problem-tp3148712p3148712.html
Sent from the MapGuide Users mailing list archive at Nabble.com.

_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users