[mapguide-users] Add features to SQL Server Spatial

[Zac Spitzer]

sdf is r/w via mapguide?

just a guess, is your feature source defined as read only?

this might help?

http://trac.osgeo.org/mapguide/ticket/649



On Tue, Oct 27, 2009 at 1:11 PM, Jamo <adam.jamison at portbris.com.au> wrote:

>
> I think mapguide api only exposes sdf write capabilities?
> Might have to do it through fdos
>
> Rodolfo Moreno wrote:
> >
> > why don't you insert sql features using SQL spatial scripts?
> >
> > Regards,
> >
> >
> > Gunter Becker wrote:
> >>
> >> Is there at least anyone who had successfully added features to SQL
> >> Server 2008 Spatial with the MapGuide API. What could cause problems
> when
> >> adding features to the database?
> >>
> >> I think there was another thread (
> >>
> http://n2.nabble.com/MSSqlServer-Spatial-problem-tt3148712.html#a3154109
> >> MSSqlServer Spatial problem ) that describes a similar problem.
> >> But this problem had to do with 3-dimensional point what is not what i
> am
> >> using. I am using x,y-points.
> >>
> >> Any ideas?
> >>
> >> Gunter
> >>
> >>
> >>
> >> Gunter Becker wrote:
> >>>
> >>> Hi,
> >>>
> >>> i'm trying to add features to an existing FeatureSource via MapGuide
> >>> API. I've created a new schema with Autodesk Map 2010, created some
> >>> polygons, created my feature source and layer in MapGuide Studio,
> >>> inserted the layer in my map and it shows up fine.
> >>>
> >>> OK, displaying the features works fine. But when trying to add some
> >>> features via the digitize function and my serverside code nothing
> >>> happens. It seemes that the code works fine, cause it is the same code
> >>> that I use with sdf feature sources and the code throws no error in
> >>> debug mode. The "UpdateFeatures"-Methode seems to work but when looking
> >>> into the SQL Server table there is no entry and therefore no object on
> >>> the map. When logging SQL-Statements with SQL Profiler no activities
> >>> were logged.
> >>>
> >>> Only thing that works is deleting an existing map from the
> >>> featuresource. So maybe it has to do something with the
> >>> coordinatesystem? But as far as I understand the geometry-column of my
> >>> databasetable doesn't need a coordinatesystem assigned!
> >>>
> >>> Someone who had same problem? Any ideas?
> >>>
> >>> Thanks, Gunter
> >>>
> >>
> >>
> >
> >
>
> --
> View this message in context:
> http://n2.nabble.com/Add-features-to-SQL-Server-Spatial-tp3878130p3896621.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
>



-- 
Zac Spitzer -
http://zacster.blogspot.com
+61 405 847 168
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20091027/e4f14527/attachment.html