[mapguide-users] SHP to SQL Server 2008 spatial

Jackie Ng jumpinjackie at gmail.com
Mon Jan 5 18:45:05 EST 2009


Hi Peter,

You could have an invalid geometry in the SHP file that is tripping up the
bulk copy process. 

This isn't really an issue with MapGuide at all. So post a new issue to the
Google Code project site, or send me an email (to continue this discussion).

- Jackie


Peter Filip wrote:
> 
> Hi,
> 
> i'd like to load a SHP file into a SQL Server 2008 database and then view
> this data throught MGOS.
> 
> I played around with FDOToolbox, but I wasn't successful. 
> I did it this way:
> 
> 1. I created a new data store. 
> 2. I created a new data connection to my SHP file and to the data
> store(SQLserver).
> 3. Then i created a new bulk copy. I set the SHP file as a source and the
> SQLserver data store as a target. 
> Here i get a message: There are no schemas in the target connection. If
> you save this task, all source classes will be copied.
> 
> Anyway I executed the bulkcopy and got this output with an error message:
> 
> [5.1.2009 23:23:38] OSGeo.FDO.Common.Exception: String is not a valid FGF
> string.  ---> OSGeo.FDO.Common.Exception: Parse string is incorrectly
> formatted. 
> 
> 
> Maybe I did it wrong or is there any other way to load SHP files to SQL
> Server 2008 ? 
> 
> I'll appreciate any suggestions.
> 
> 
>   
> 

-- 
View this message in context: http://n2.nabble.com/SHP-to-SQL-Server-2008-spatial-tp2115403p2115540.html
Sent from the MapGuide Users mailing list archive at Nabble.com.



More information about the mapguide-users mailing list