2011

Table Of Contents
Edit a PostgreSQL/PostGIS schema (page 610)
Delete a PostgreSQL/PostGIS schema (page 613)
Copy data to/from a different data format (page 615)
Working with ODBC Data
To set up a Data Source Name (DSN) for your ODBC data store, you add a DSN
in Windows. The configuration options you specify depend on the type of
ODBC data store you use. The login ID and password you enter when setting
up your DSN are used only for defining the DSN. These credentials are not
when you connect with the ODBC provider through FDO.
NOTE For MySQL, be sure to install the MySQL driver from MyODBC 3.51 at
http://dev.mysql.com/downloads/connector/odbc/3.51.html.
NOTE This functionality affects geospatial feature data only. For information about
linking records in an external database to objects in a drawing, see
Overview of
Linking Database Records to Objects
(page 522).
What ODBC Schemas Support
For ODBC, AutoCAD Map 3D supports point geometry, with X, Y, and
optionally, Z columns for defining points. Although the default column names
are X, Y, and Z, when you select the columns to represent these points, you
must override the defaults. This information is stored in the map file itself. If
you perform the same steps in another map, you must override the settings
again.
In some cases, ODBC schemas support default values.
Restrictions of ODBC Schemas
There is no spatial indexing.
Geometry points are stored as separate properties in the object definition.
The existing
schema (page 2073) is used; you cannot edit or delete it. You
cannot add a new schema or add
FDO (page 2062) metadata to the data store
(page 2059).
576 | Chapter 4 Managing Data