Connecting to a Database

First, let's discuss how to connect a drawing to a database. You can use two methods to access an external database: either ODBC or OLE DB. Both of these methods allow a connection to be made to the database, acting as a sort of translator to get to the data regardless of specific platform or database structure.

Using ODBC to Make the Connection

The first method is to use the Microsoft Windows Open Database Connection (ODBC) by creating a Data Source Name (DSN). The DSN is essentially the name given to the ODBC connection for a particular database. You can think of the DSN and ODBC combination as an administrator who controls the specifics of how to connect to the database. A DSN can be created through the Windows Control ...

Get Special Edition Using AutoCAD® 2000 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.