APPX Software Library

Chapter 3: ODBC Driver Conformance

3.4 Supported ODBC API Functions

The ODBC Driver supports all Core and Level 1 API functions, and most Level 2 functions. Here is a complete list of the functions the driver supports. Applications can request this same information through the SQLGetFunctions function with a FunctionId of SQL_API_ODBC3_ALL_FUNCTIONS.

  • SQLAllocConnect (Deprecated in ODBC 3.0)
  • SQLAllocEnv (Deprecated in ODBC 3.0)
  • SQLAllocHandle
  • SQLAllocStmt (Deprecated in ODBC 3.0)
  • SQLBindCol
  • SQLBindParam (Deprecated in ODBC 3.0)
  • SQLBindParameter
  • SQLBrowseConnect
  • SQLCancel
  • SQLCloseCursor
  • SQLColAttribute
  • SQLColAttributes (Deprecated in ODBC 3.0)
  • SQLColumnPrivileges
  • SQLColumns
  • SQLConnect
  • SQLCopyDesc
  • SQLDataSources
  • SQLDescribeCol
  • SQLDescribeParam
  • SQLDisconnect
  • SQLDriverConnect
  • SQLDrivers
  • SQLEndTran
  • SQLError (Deprecated in ODBC 3.0)
  • SQLExecDirect
  • SQLExecute
  • SQLExtendedFetch (Deprecated in ODBC 3.0)
  • SQLFetch
  • SQLFetchScroll
  • SQLForeignKeys
  • SQLFreeConnect (Deprecated in ODBC 3.0)
  • SQLFreeEnv (Deprecated in ODBC 3.0)
  • SQLFreeHandle
  • SQLFreeStmt (Deprecated in ODBC 3.0)
  • SQLGetConnectAttr
  • SQLGetConnectOption (Deprecated in ODBC 3.0)
  • SQLGetCursorName
  • SQLGetData
  • SQLGetDescField
  • SQLGetDescRec
  • SQLGetDiagField
  • SQLGetDiagRec
  • SQLGetEnvAttr
  • SQLGetFunctions
  • SQLGetInfo
  • SQLGetStmtAttr
  • SQLGetStmtOption (Deprecated in ODBC 3.0)
  • SQLGetTypeInfo
  • SQLMoreResults
  • SQLNativeSql
  • SQLNumParams
  • SQLNumResultCols
  • SQLParamData
  • SQLParamOptions (Deprecated in ODBC 3.0)
  • SQLPrepare
  • SQLPrimaryKeys
  • SQLProcedureColumns
  • SQLProcedures
  • SQLPutData
  • SQLRowCount
  • SQLSetConnectAttr
  • SQLSetConnectOption (Deprecated in ODBC 3.0)
  • SQLSetCursorName
  • SQLSetDescField
  • SQLSetDescRec
  • SQLSetEnvAttr
  • SQLSetParam (Deprecated in ODBC 3.0)
  • SQLSetScrollOptions
  • SQLSetStmtAttr
  • SQLSetStmtOption (Deprecated in ODBC 3.0)
  • SQLSpecialColumns
  • SQLStatistics
  • SQLTablePrivileges
  • SQLTables
  • SQLTransact (Deprecated in ODBC 3.0)