Exercise 2: Connect to the Access database

Exercise 1: Set up an ODBC connection for an Access database

Lesson 2: Analyzing Data With External Information Using Joins

Exercise 3: Join the data from the ODBC source to the layer containing the parcels

 

AutoCAD Map 3D Tutorials > Tutorial: Analyzing Data Using Styles, Joins, and Buffers > Lesson 2: Analyzing Data With External Information Using Joins > 

Exercise 2: Connect to the Access database

Specify the new connection in Data Connect. You don't need to add any specific feature class layers from the ODBC source to the map. All the information becomes available to AutoCAD Map 3D automatically when you connect to the ODBC source.

To connect to the Access database from AutoCAD Map 3D

1. In Display Manager in AutoCAD Map 3D, click Data Connect To Data.
2. In the Data Connect dialog box, under Data Connections By Provider, click Add ODBC Connection.
3. Click the button next to the Source field under Add A New Connection.
4. In the Open dialog box, select Parcel_Owners from the list of Data Source Names and click Select.

   

   Connect to the ODBC data source the same way you did to the surface and SDF data sources.

5. Click Connect.
6. In the User Name & Password dialog box, click Login without entering anything in the fields. (This database has not been set up for user name and password protection.)

   Do not add any layers to your map. AutoCAD Map 3D sees all non-spatial data automatically after you connect to its source.

7. Close the Data Connect window without adding anything to your map.

To continue this tutorial, go to Exercise 3: Join the data from the ODBC source to the layer containing the parcels.