API Functions

The DataDirect Connect for ODBC driver is Level 1 compliant, that is, it supports all ODBC Core and Level 1 functions. It also supports a limited set of Level 2 functions, as described in the following table.

Table 4. Function Conformance for 2.x ODBC Applications
Core Functions	Level 1 Functions	Level 2 Functions
SQLAllocConnect SQLAllocEnv SQLAllocStmt SQLBindCol SQLBindParameter SQLCancel SQLColAttributes SQLConnect SQLDescribeCol SQLDisconnect SQLDrivers SQLError SQLExecDirect SQLExecute SQLFetch SQLFreeConnect SQLFreeEnv SQLFreeStmt SQLGetCursorName SQLNumResultCols SQLPrepare SQLRowCount SQLSetCursorName SQLTransact	SQLColumns SQLDriverConnect SQLGetConnectOption SQLGetData SQLGetFunctions SQLGetInfo SQLGetStmtOption SQLGetTypeInfo SQLParamData SQLPutData SQLSetConnectOption SQLSetStmtOption SQLSpecialColumns SQLStatistics SQLTables	SQLBrowseConnect (except for Progress) SQLDataSources SQLDescribeParam SQLExtendedFetch (forward scrolling only) SQLMoreResults SQLNativeSql SQLNumParams SQLParamOptions SQLSetScrollOptions

The Level 3 functions that the driver supports are listed in the following table. Any additions to these supported functions or differences in the support of specific functions are listed in the individual driver chapters in the DataDirect Connect for ODBC User's Guide.

Table 5. Function Conformance for 3.x ODBC Applications
SQLAllocHandle SQLBindCol SQLBindParameter SQLBrowseConnect (except for Progress) SQLBulkOperations SQLCancel SQLCloseCursor SQLColAttribute SQLColumns SQLConnect SQLCopyDesc SQLDataSources SQLDescribeCol SQLDisconnect SQLDriverConnect SQLDrivers SQLEndTran SQLError SQLExecDirect SQLExecute SQLExtendedFetch SQLFetch SQLFetchScroll (forward scrolling only) SQLFreeHandle SQLFreeStmt SQLGetConnectAttr SQLGetCursorName SQLGetData	SQLGetDescField SQLGetDescRec SQLGetDiagField SQLGetDiagRec SQLGetEnvAttr SQLGetFunctions SQLGetInfo SQLGetStmtAttr SQLGetTypeInfo SQLMoreResults SQLNativeSql SQLNumParens SQLNumResultCols SQLParamData SQLPrepare SQLPutData SQLRowCount SQLSetConnectAttr SQLSetCursorName SQLSetDescField SQLSetDescRec SQLSetEnvAttr SQLSetStmtAttr SQLSpecialColumns SQLStatistics SQLTables SQLTransact