ODBC drivers can be classified as follows:
32-bit ODBC 2.x Driver. A 32-bit driver that:
Exports only ODBC 2.x functions.
Exhibits ODBC 2.x behavior for behavioral changes.
ISO and X/Open compliant driver. A 32-bit driver that:
Exports all functions that are documented in the X/Open or ISO CLI documents.
This will include some of functions that are deprecated in ODBC.
Exhibits ODBC 3.0 behavior for behavioral changes.
Does not necessarily go through the ODBC 3.0 Driver Manager.
ODBC 3.0 Driver. A 32-bit driver that:
Exports only functions that are in ODBC 3.0 minus deprecated functions.
Is capable of exhibiting ODBC 2.x behavior or ODBC 3.0 behavior with respect to behavioral changes, based on the
SQL_ATTR_APP_ODBC_VERSION environment attribute.
Note 16-bit ODBC drivers will not work with the ODBC 3.0 Driver Manager. Existing 16-bit applications will work only with the ODBC 2.x Driver Manager.