O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required