ODBC API Functions
- Last Updated: May 12, 2026
- 2 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
The 32-bit and 64-bit ODBC drivers are ODBC Level 1–compliant, supporting all ODBC Core and Level 1 functions. Most Level 2 functions are also supported. The following tables list supported functions for ODBC 2.x and ODBC 3.x applications, respectively.
- On Linux and UNIX 64-bit platforms, the compiler flag, ODBC64, must be set.
- On Linux and UNIX, the ODBC header files for the DataDirect Driver Manager are installed in the installdir/include directory.
- On Windows, the ODBC header files are installed with the MDAC installation.
Function Conformance for 2.x ODBC Application
| Core 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 |
| Level 1 Functions | |
| SQLColumns SQLGetConnectOption SQLGetData SQLDriverConnect SQLGetFunctions SQLGetInfo SQLGetStmtOption SQLGetTypeInfo |
SQLParamData SQLPutData SQLSetConnectOption SQLSetStmtOption SQLSpecialColumns SQLStatistics SQLTables |
| Level 2 Functions | |
| SQLDataSources SQLExtendedFetch SQLMoreResults SQLNativeSql |
SQLNumParams SQLParamOptions SQLSetScrollOptions |
Function Conformance for 3.x ODBC Applications
| SQLAllocHandle SQLBindCol SQLBindParam SQLBindParameter SQLBulkOperations SQLCancel SQLCloseCursor SQLColAttribute SQLColAttributes SQLColumnPrivileges SQLColumns SQLConnect SQLCopyDesc SQLDataSources SQLDescribeCol SQLDescribeParam1 SQLDisconnect SQLDriverConnect SQLDrivers SQLEndTran SQLExecDirect |
SQLFreeHandle SQLFreeStmt SQLGetConnectAttr SQLGetCursorName SQLGetData SQLGetDescField SQLGetDescRec SQLGetDiagField SQLGetDiagRec SQLGetEnvAttr SQLGetFunctions SQLGetInfo SQLGetStmtAttr SQLGetTypeInfo SQLMoreResults SQLNativeSql |
SQLProcedureColumns SQLProcedures SQLPutData SQLRowCount SQLSetConnectAttr SQLSetCursorName SQLSetDescField SQLSetDescRec SQLSetEnvAttr SQLSetPos SQLSetStmtAttr SQLSpecialColumns SQLStatistics SQLTablePrivileges SQLTables SQLTransact |
1 Parameter descriptors are supplied when using the OpenAccess SDK SQL engine. Some third-party SQL engines might not support the functionality required by SQLDescribeParam. Instead, use the DataSourceEnableDescribeParam service attribute, described in the OpenAccess SDK Administrator’s Guide.
Notes:
The following are expected behaviors when using the 32-bit ODBC client driver for 64-bit row count operations, because the ODBC specification does not support 64-bit row count operations using the 32-bit ODBC client driver:
- The driver returns incorrect row count value for DDL statements, such as INSERT, UPDATE, or DELETE.
- The SQL_ATTR_MAX_ROWS attribute value for the for the SQLSetStmtAttr function cannot exceed the integer value of 32.