[mapguide-users] Add features to SQL Server Spatial

[Gunter Becker]

Zac, your right. I'm facing the same bug you've described in this ticket. No
errors were thrown when updating my feature source and I didn't recognise
that the updatefeature methode has a return value. So when I debug my code I
see that a MgStringProperty is returned. The value of this string is:

An exception occurred in FDO component. Item 'Persons' not found in
collection

OK, now I get at least an error but don't know how to interpret it.
'Persons' is the classname of my feature source (and the tablename in SQL
Server).

I think my feature source is not defined as read only, because using
MgDeleteFeatures works fine and the SQL Server account which I'm using has
read-write access.
Like I said in my first post I can delete features but I'm not able to
create them. 

Thanks, Gunter




zspitzer wrote:
> 
> 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
> 
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 

-- 
View this message in context: http://n2.nabble.com/Add-features-to-SQL-Server-Spatial-tp3878130p3897516.html
Sent from the MapGuide Users mailing list archive at Nabble.com.