skip to main content
Developing ODBC Applications : ODBC API Functions
 

ODBC API Functions

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.
 
Table 3: 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
 
Table 4: 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
SQLExecute
SQLExtendedFetch
SQLFetch
SQLFetchScroll
SQLForeignKeys
SQLFreeHandle
SQLFreeStmt
SQLGetConnectAttr
SQLGetCursorName
SQLGetData
SQLGetDescField
SQLGetDescRec
SQLGetDiagField
SQLGetDiagRec
SQLGetEnvAttr
SQLGetFunctions
SQLGetInfo
SQLGetStmtAttr
SQLGetTypeInfo
SQLMoreResults
SQLNativeSql
SQLNumParams
SQLNumResultCols
SQLParamData
SQLPrepare
SQLPrimaryKeys
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.