Progress DataDirect for ODBC drivers are Level 1 compliant, and support ODBC Core and Level 1 functions. As described in the following table, a limited set of Level 2 functions are also supported.

Table 1. Function Conformance for ODBC 2.x 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

SQLDataSources

SQLDescribeParam

SQLExtendedFetch (forward scrolling only)

SQLMoreResults

SQLNativeSql

SQLNumParams

SQLParamOptions

SQLSetScrollOptions

The functions for ODBC 3.x Applications that the drivers support are listed in the following table. For any additions to these supported functions or differences in the support of specific functions, refer to "ODBC compliance" or "ODBC conformance" in the user's guide for your driver.

Table 2. Function Conformance for ODBC 3.x 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