[mapguide-users] Add features to SQL Server Spatial

[Rodolfo Moreno]

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
>> 
> 
> 


-----
Rodolfo Moreno
CivilEng

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