Changes between Version 1 and Version 2 of FdoSQLServerSpatialNotes
- Timestamp:
- Mar 18, 2008, 8:07:05 AM (16 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
FdoSQLServerSpatialNotes
v1 v2 11 11 '''Setting up the provider.''' 12 12 13 At this time, until we build an actual install tool, what we’re doing to set this up for MapGuide 2009 and other clients is to replace the current SQL Server provider via the providers.xml file. Take the new dlls and drop them into the fdo bin directories for your client applications (e.g. C:\Program Files\Autodesk\MapGuideEnterprise2009\Server\Bin\Fdo on my machine). Update the providers.xml file in those directories by finding the entry for the current SQL Server provider and modify the dll name. You can change the description as well to indicate 2008 if you want. 14 Here is what it should look like after changing the dll name and description: 13 At this time, until we build an actual install tool, what we’re doing to set this up for !MapGuide 2009 and other clients is to edit the current providers.xml file and add a <!FeatureProvider> entry for SQLServerSpatial . Take the new dlls and drop them into the fdo bin directories for your client applications (e.g. C:\Program Files\Autodesk\!MapGuideEnterprise2009\Server\Bin\Fdo on my machine). Update the providers.xml file in those directories by adding the entry for the SQL Server Spatial provider. 14 15 Here is the <!FeatureProvider> sectrion to add for SQL Server Spatial: 15 16 16 17 {{{ 17 18 18 19 <FeatureProvider> 19 <Name>Autodesk.SqlServer.3.3</Name>20 <DisplayName>Autodesk FDO Provider for SQL Server </DisplayName>21 <Description>Read/write access to feature data in a MS SQL Server 2008-based data store. Supports geospatial and nongeospatial data and schema R/W access. </Description>22 <IsManaged>False</IsManaged>23 <Version>3.3.0.0</Version>24 <FeatureDataObjectsVersion>3.3.0.0</FeatureDataObjectsVersion>25 <LibraryPath>SqlServerSpatialProvider.dll</LibraryPath>26 20 <Name>OSGeo.SQLServerSpatial.3.3</Name> 21 <DisplayName>OSGeo FDO Provider for SQL Server Spatial</DisplayName> 22 <Description>Read/Write access to feature data in a MS SQL Server spatially enabled data store. Supports geospatial and non-geospatial data and schema.</Description> 23 <IsManaged>False</IsManaged> 24 <Version>3.3.0.0</Version> 25 <FeatureDataObjectsVersion>3.3.0.0</FeatureDataObjectsVersion> 26 <LibraryPath>SQLServerSpatialProvider.dll</LibraryPath> 27 </FeatureProvider> 27 28 28 29 }}} 29 30 30 You may change the display name and description as well, but nothing else.31 31 Now, after installing the new dll's as described above, you can run MG 2009 or other clients based on FDO 3.3. Connect to 'localhost' and use the sa user and pwd that you defined when installing SQL 2008 or other SQL Server user account that you created.
