[mapguide-users] SQL Server 2005

Jason Birch Jason.Birch at nanaimo.ca
Wed Oct 4 15:07:57 EDT 2006


Hi,
 
I just had an interesting comment on my blog:
 
http://www.jasonbirch.com/nodes/2006/09/28/37/fdo-a-gogo/#comment-547 <http://www.jasonbirch.com/nodes/2006/09/28/37/fdo-a-gogo/#comment-547> 
 
If anyone's willing to collaborate with the developer of the open source MS SQL Spatial extensions in developing an open source FDO Provider for MSSQL, this would really enhance the ability of MapGuide to reach across enterprise boundaries.  
 
Features:
http://www.codeplex.com/Wiki/View.aspx?ProjectName=MsSqlSpatial&title=Features
 
It's cool that it uses a .Net port of JTS.  Unfortunately doesn't support curves (yet?).
 
Contact the developer:
http://www.codeplex.com/Project/ListForums.aspx?ProjectName=MsSqlSpatial
 
I know that supporting non-open technologies is not popular with some open source advocates, but sometimes you need to build a bridge to cross a river.  In some cases it's more like a moat filled with crocodiles around an entrenched enterprise :)
 
Jason

________________________________

From: Robert Fortin [mailto:robert.fortin at autodesk.com]
Sent: Wed 2006-10-04 6:39 AM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] SQL Server 2005


The SQL Server provider is intented to work with datastore created with Map 3D 2007 inside SQL Server 2000 and 2005.
It has it's own geometry storage and spatial indexing mechanism.  Although it could reverse engineer existing database, this would be done for non-spatial data only as it has no mean to identify geometry property in the database.
 
In case you have X,Y,Z coordinates stored in different columns, the ODBC provider should be used against SQL Server data.
 
Just wanted to make sure the provider was not being used for what it was not design for.
 
RF

________________________________

From: Lockyer James [mailto:James.Lockyer at bradford.nhs.uk] 
Sent: Wednesday, October 04, 2006 2:59 AM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] SQL Server 2005


Supported yes - does it work... now that's the question.

 
________________________________

From: Gord McKenzie [mailto:gord.mckenzie at canam.com]
Sent: Tue 03/10/2006 22:04
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] SQL Server 2005



Thanks

 

________________________________

From: Warren Medernach [mailto:warren.medernach at imaginit.ca] 
Sent: Tuesday, October 03, 2006 1:33 PM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] SQL Server 2005

 

Hello Gord,

 

I was informed by the ADN that the FDO provider supports: SQL Server 2000 (SP4) and SQL Server 2005.

 

Warren Medernach

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 8193 bytes
Desc: not available
Url : http://lists.osgeo.org/pipermail/mapguide-users/attachments/20061004/0f4c6535/attachment.bin


More information about the Mapguide-users mailing list