O'Reilly logo

DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition by Michael Kyprianou, Steve Sanyal, Kevin Gashyna, David Martineau

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

CLI and ODBC Overview

How do ODBC and CLI fit together? IBM's CLI driver implements most of the function set that is defined by Microsoft's ODBC. Microsoft supplies a Driver Manager that manages many different vendors' drivers such as IBM's CLI for the Windows environment. A Windows application that wants to use ODBC to access a database is dynamically linked to the ODBC Driver Manager and makes a function call to it such as SQLConnect(). The Manager then finds this function in the appropriate vendor supplied driver, such as IBM's CLI driver, and uses it to communicate to the DBMS (in this case, it connects to a database).

A program does not necessarily need to be dynamically linked to the ODBC Driver Manager to access a DB2 database. It could, ...

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