The following table shows, among ODBC 2.x functions, the ones that can be used in ODBC 3.x instead of the ones not supported, according to the backward compatibility.
ODBC 2.x function |
ODBC 3.x function |
SQLAllocConnect |
SQLAllocHandle |
SQLAllocEnv |
SQLAllocHandle |
SQLAllocStmt |
SQLAllocHandle |
SQLBindParam |
SQLBindParameter |
SQLColAttributes |
SQLColAttribute |
SQLError |
SQLGetDiagRec |
SQLFreeConnect |
SQLFreeHandle |
SQLFreeEnv |
SQLFreeHandle |
SQLFreeStmt with SQL_DRO |
SQLFreeHandle |
SQLGetConnectOption |
SQLGetConnectAttr |
SQLGetStmtOption |
SQLGetStmtAttr |
SQLParamOptions |
SQLSetStmtAttr |
SQLSetConnectOption |
SQLSetConnectAttr |
SQLSetParam |
SQLBindParameter |
SQLSetScrollOption |
SQLSetStmtAttr |
SQLSetStmtOption |
SQLSetStmtAttr |
SQLTransact |
SQLEndTran |