• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 22. External Database Connection > Connecting to a Database

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 Panel using the ODBC Data Source Admin- istrator. Clicking the ODBC Data Sources icon launches a setup routine that prompts you for the DSN and for the details of connecting to your database. Using ODBC, you can connect to the following types of databases or spreadsheets:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint