To Bring In Features from SQL Server

AutoCAD Map 3D supports both SQL Server and SQL Server Spatial.

To bring in features from SQL Server

  1. In Display Manager , click DataConnect To Data.
  2. In the Data Connect window, select Add SQL Server Connection in the Data Connections By Provider list.
  3. Under Connection Name, type a name for this connection.
  4. Under Service Name, enter the information for the SQL Server data source. If you do not know the name, check with your System Administrator.
  5. Click Login.
  6. In the User Credentials dialog box, enter your user name and password.

    Optionally, select Remember Password if you want AutoCAD Map 3D to log you in whenever you open this drawing.

  7. Click OK.
  8. In Data Connect, under Data Store, enter the data store name. If you do not know this name, check with your System Administrator.

    To select from a list of data stores, click the down arrow. AutoCAD Map 3D connects to the specified server and instance and lists the available data stores.

  9. Click Connect.
  10. In the feature class list, select the feature classes to include in the map.

    If this feature source contains only a single feature class, that feature class is selected automatically. If it contains multiple feature classes, you can do either of the following:

    • Right-click the schema entry and select Select All or Select None.
    • Expand the schema entry and select the feature classes to add.

      If a feature class contains multiple geometry types,and you select the feature class itself, all geometries are added. To add a subset of geometries, hold your cursor over the feature class name to see the Show Geometry button. Click Show Geometry to see each geometry as a separate choice. Select the ones you want. Each selected geometry is added to map as a separate Display Manager layer.

  11. Click Add To Map.

To use AutoCAD Map 3D 2015 to access FDO data stores that were created in AutoCAD Map 3D 2007 and earlier

  1. Verify that you have the privileges required to execute the ALTER TABLE request.
  2. In the command line, enter the following:

    cd <MapInstallDir>/Fdo/bin/com

  3. Do one of the following:
    • For SQL Server 2005, enter sqlcmd -UMyUserName -P MyPassword -S SQLServerHostName -d MyDatastore -i AlterSchemaSQLServer.sql
    • For SQL Server 2000, enter isql -UMyUserName -P MyPassword -S SQLServerHostName -d MyDatastore -i AlterSchemaSQLServer.sql