Changes between Version 1 and Version 2 of FdoSQLServerSpatialNotes


Ignore:
Timestamp:
03/18/08 08:07:05 (17 years ago)
Author:
gregboone
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • FdoSQLServerSpatialNotes

    v1 v2  
    1111'''Setting up the provider.'''
    1212
    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:
     13At 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
     15Here is the <!FeatureProvider> sectrion to add for SQL Server Spatial:
    1516
    1617{{{
    1718
    1819<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   </FeatureProvider>
     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>
    2728
    2829}}}
    2930
    30 You may change the display name and description as well, but nothing else.
    3131Now, 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.