2011

exists in the data source directory, you can attach the data source to any
drawing.
For most data sources, AutoCAD Map 3D creates the UDL file automatically
when you attach a database. However, for some database types, you must
create the UDL file manually.
When you edit or create a UDL file, you use the Microsoft Windows Data Link
Properties dialog box. For more information on using this dialog box, refer to
your Microsoft Windows documentation.
NOTE This functionality is for drawing objects only. For information about joining
an external database to a geospatial feature class, see
Joining Data to GIS Features
(page 507).
Drivers
To read external data files, AutoCAD Map 3D uses drivers that translate the
data to a standard format. The first time you use a data source with AutoCAD
Map 3D, AutoCAD Map 3D determines the appropriate driver for the data
source. It stores this information in the UDL file.
AutoCAD Map 3D supports these drivers:
■ Jet provider, which works with Microsoft Access database files
■ SQL Server provider
■ Oracle provider
■ ODBC driver, which works with ODBC-compliant databases
These drivers are installed with AutoCAD Map 3D.
Because the ODBC provider works with many different database types, it
requires additional information about each specific database type. It gets this
information from a Data Source Name (DSN) that registers information about
the database type. You need only one DSN for each database type.
For the following ODBC-compliant databases, AutoCAD Map 3D creates a
DSN for you when you attach the database:
■ Microsoft Access
■ dBase
■ Microsoft Excel
■ Paradox
Setting Up Data Sources for Drawings | 211