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

Understanding ODBC Drivers

The ODBC API consists of a driver manager and one or more ODBC drivers, as illustrated by the shaded boxes in Figure 25.2. Windows uses drivers to adapt its standard API to specific combinations of hardware such as displays, keyboards, and printers. Likewise, the ODBC API uses drivers to translate instructions passed from the application through the driver manager to instructions that are compatible with various RDBMSs. When the ODBC driver manager receives instructions from Access that are intended for a data source, such as a SQL Server database, the driver manager opens the appropriate ODBC driver for the database. The relationship of the ODBC driver manager and ODBC drivers parallels the relationship of Access 97's built-in, 32-bit Jet 3.5 database engine and the 32-bit ISAM drivers that are used to connect to Access, dBASE, FoxPro, and Paradox files.

ODBC drivers are classified as one of the following two types:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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