To bring in features from MySQL
- Before connecting to a MySQL database,
install the library file libmysql.dll.
- In Display Manager,
- In the Data Connect window,
select Add MySQL Connection in the Data Connections
By Provider list.
- Under Connection Name,
type a name for this connection.
You can give the connection any name you like.
This name appears in Map Explorer as the name of
the feature source.
- Under Service Name,
enter the information for the MySQL data source. If you do not know
the name, check with your System Administrator.
- Click Login.
- In the User Name & Password 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.
- Click OK.
- In Data Connect,
under Data Store, enter the data
store name. If you do not know this name, check with your System
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.
the data store is not in the list, it may not use a AutoCAD Map 3D schema.
Select Show All Data Stores to add
these to the list. AutoCAD Map 3D creates a mapping to use these data
stores with AutoCAD Map 3D.
- Click Connect.
- 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 right-click
any of them and select Select All or Select
- Click Add To Map.
To bring in a subset
of the data, click the down arrow and select Add
To Map With Query. To filter data after
you’ve added the data to your map, see Filtering Feature Layers.
Features from the selected
feature classes appear in your map. You can style, theme, and edit
If you need additional
properties related to this data, you can connect additional data
to a feature source layer using a join.
To use AutoCAD Map 3D 2010 to access FDO data
stores that were created in AutoCAD Map 3D 2007 and earlier
- Verify that you have the privileges required
to execute the ALTER TABLE request.
- In the command line, enter the following:
--user=MyUserName --password=MyPasswordMyDatabase <AlterSchemaMySQL.sql>