The ODBC API is a complex set of functions that provides common interfaces for accessing various background databases. For today's client/server applications, each database system has its own interface, for example, the interfaces provided by various database systems, such as SQL SERVER,ORACLE,DB2 and Infomix, are completely different. This is a very frustrating thing for programmers.
The appearance of ODBC becomes a flashed, after adding an additional layer, users only need to learn and master a set of sets of functions, then you can directly use the majority of any database system features. However, do not assume that ODBC provides a unified interface, but also provides a simple operation. In fact, the use of the ODBC API is very complex. So why do you want to use the ODBC API in VB? Because although RDO implements some of the features of ODBC, but not all of them, the ODBC API provides the best functionality.