Configure External Databases
Before you can access
external databases from AutoCAD®, you must configure
them using the Microsoft® external ODBC and OLE
NoteThe 64-bit release of AutoCAD does
not support the use of Microsoft Jet 4.0 OLE DB Provider (for MDB
connectivity) and Microsoft OLE DB Provider for ODBC Drivers (for
XLS connectivity). For more information, see Substituting the use
of SQL Server instead of OLE DB with DbConnect.
Once you have configured your databases, you
can access their data from AutoCAD, even if you don't have the
database system that created the data installed on your system. AutoCAD can
access data from the following applications:
NoteWith MDAC versions 2.1
and higher, you can't edit dBase files unless you have a Borland
DataBase Engine (BDE) installed on your computer.
have successfully configured a database to use with AutoCAD,
a configuration file with the extension UDL is created. This configuration
file contains the information AutoCAD needs to access the configured
database. By default, UDL files are stored in the Data
Links folder of AutoCAD. You can specify a different
location for UDL files from the Options dialog box.
topics demonstrate how to set up a data source using ODBC, and how
to configure data sources so that you can use them with AutoCAD.
For detailed information about ODBC and OLE DB, refer to the following
online Microsoft resources:
Microsoft Desktop Database Drivers
Bypass ODBC Using an OLE DB Direct Driver
Several database management systems supported
by AutoCAD have direct drivers available for OLE DB. If you use
these direct drivers, you don't need to set up configuration files
from within both ODBC and OLE DB; you only need a single OLE DB
database drivers are available for the following database systems:
Use ODBC to Create a Configuration File
is an intermediary program that makes data from one application available
to other applications.
Configure a Data Source with OLE DB
You can use OLE DB to establish
a UDL configuration file that points to an external database table.
Substituting SQL Server for OLE DB
you are using the 64-bit release of AutoCAD and DbConnect with
a connection that accesses a Microsoft Access database or a Microsoft
Excel spreadsheet using one of the two following methods, you need
to change your connections to use Microsoft SQL Server. Microsoft
does not supporting a 64-bit version of these technologies.
Jet 4.0 OLE DB Provider (for MDB connectivity)
OLE DB Provider for ODBC Drivers (for XLS connectivity)
SQL Server comes in three different editions. If you are accessing data
from an MDB or XLS file today, you might find that using Microsoft
SQL Server Express Edition is adequate for your needs. Microsoft
also offers Standard and Enterprise editions of SQL Server. For
additional information about SQL Server, visit Microsoft’s website
can purchase inexpensive third-party utilities to help automate
the conversion of data stored in a MDB to a MDF file that can be
used with SQL Server. Many of these utilities also allow you to
export data from a MDF to a MDB file.
specify a new location for UDL files
set up a direct Microsoft Access configuration using OLE DB
set up a direct Oracle configuration using OLE DB
set up a direct SQL Server configuration using OLE DB
set up a Microsoft Access data source using ODBC
set up a dBase data source using ODBC
set up a Microsoft Excel spreadsheet to use with AutoCAD
NoteMicrosoft Excel is not
a true database management system. In order to access Excel data
from within AutoCAD, you must first specify at least one named
range of Excel cells to function as a database table. Each named
range of cells that you specify within a spreadsheet is treated
as an individual table by AutoCAD.
set up a Microsoft Excel data source using ODBC
set up an Oracle data source using ODBC
set up a Paradox data source using ODBC
set up a Microsoft Visual FoxPro data source using ODBC
set up an SQL Server data source using ODBC
configure a data source using OLE DB
You can use OLE DB to establish a UDL configuration
file that points to an external database table.
Microsoft ODBC to set up a data source (see
Use ODBC to Create a Configuration File).
the Data Link Properties dialog box, the Provider tab, select Microsoft OLE
DB Provider for ODBC Drivers. Choose Next.
the name of the data source you want to configure in Use Data Source
Test Connection to verify that your configuration is working properly.
connection fails, verify that the settings are correct. For example, spelling
errors and case sensitivity may be the cause of a failed connection.
the Microsoft Data Link dialog box, click OK.