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: [email protected] [mailto:[email protected]] On Behalf Of zolinko Sent: Wednesday, June 24, 2009 7:27 AM To: [email protected] 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 [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
