2004
Table Of Contents
- Contents
- Chapter 1 - Find the Information You Need
- Part 1 - The User Interface
- Part 2 - Start, Organize, and Save a Drawing
- Part 3 - Control the Drawing Views
- Part 4 - Create and Modify Objects
- Chapter 14 - Control the Properties of Objects
- Chapter 15 - Use Precision Tools
- Chapter 16 - Draw Geometric Objects
- Chapter 17 - Change Existing Objects
- Part 5 - Hatches, Notes, and Dimensions
- Chapter 18 - Hatches, Fills, and Wipeouts
- Chapter 19 - Notes and Labels
- Chapter 20 - Dimensions and Tolerances
- Part 6 - Create Layouts and Plot Drawings
- Chapter 21 - Create Layouts
- Chapter 22 - Plot Drawings
- Part 7 - Share Data Between Drawings and Applications
- Chapter 23 - Reference Other Drawing Files (Xrefs)
- Chapter 24 - Link and Embed Data (OLE)
- Chapter 25 - Work with Data in Other Formats
- Chapter 26 - Access External Databases
- Overview of Using AutoCAD with External Databases
- Access a Database from Within AutoCAD
- Link Database Records to Graphical Objects
- Use Labels to Display Database Information in the Drawing
- Use Queries to Filter Database Information
- Share Link and Label Templates and Queries with Other Users
- Work with Links in Files from Earlier Releases
- Part 8 - Work with Other People and Organizations
- Chapter 27 - Protect and Sign Drawings
- Chapter 28 - Use the Internet to Share Drawings
- Chapter 29 - Insert and View Markups
- Chapter 30 - Publish Drawing Sets
- Part 9 - Create Realistic Images and Graphics
- Glossary
- Index
730 | Chapter 26 Access External Databases
these variations, it is not possible to provide a generic configuration
procedure that works for all databases. Individual procedures for configuring
all the databases that AutoCAD supports are provided in the acad_dpg.hlp file
in the AutoCAD Help system. You should also refer to the documentation for
your particular database system and the Microsoft Help files for ODBC and
OLE DB for additional information.
The connectivity feature supports the following external applications:
■ Microsoft Access
■ dBASE
■ Microsoft Excel
®
■ Oracle
■ Paradox
■ Microsoft Visual FoxPro
®
■ SQL Server
AutoCAD includes a Microsoft Access sample database file and a preconfig-
ured direct driver (jet_dbsamples.udl) that you can use to work with the data-
base. You do not need to have Access installed. The file is located in the Sam-
ple folder, which is located in the AutoCAD installation directory. If you
moved the Sample folder to a different location, you must update the path in
the jet_dbsamples.udl configuration file before you can work with the data-
base file.
The dbConnect Manager
The dbConnect Manager is a dockable, resizable window that contains a set
of buttons and a tree view. In the dbConnect Manager, you can open the
Data View window to view or edit a database table. You can also associate var-
ious database objects (such as link templates, label templates, and queries)
with an AutoCAD drawing.