Supported ODBC API Functions

The purpose of leveling is to inform the application what features are available to it from the driver. The Microsoft ODBC Desktop Database Drivers support all Core and Level 1 functions.

For more information about conformance levels for functions and grammar, see Conformance Levels in the ODBC Programmer's Reference.

Support of ODBC API functions can be dependent on the driver used. The following table summarizes the support for functions. The leftmost column provides a link to the general reference page for each function. These reference pages are listed alphabetically in the ODBC API Reference section, under ODBC Programmer's Reference. The columns to the right provide links to driver-specific notes about each supported function. These driver-specific topics are listed in the "Other Programming Details" section for each driver. Alternatively, if the same remarks about a function apply to all the ODBC Desktop Database Drivers, the rightmost column provides a link to a topic that summarizes the Desktop Database Drivers' support for that function. These topics are listed at the end of the current section ("Supported ODBC API Functions").

ODBC Function Access Driver-specific notes dBASE Driver-specific notes Paradox Driver-specific notes Text File Driver-specific notes Excel Driver-specific notes Notes relevant to all drivers
SQLBindParameter Excel
SQLColAttributes Access dBASE Paradox Text File Excel
SQLColumns Access dBASE Paradox Text File Excel
SQLConfigDataSource Access dBASE Paradox Text File Excel
SQLDriverConnect Access dBASE Paradox Text File Excel
SQLGetCursorName All drivers
SQLGetData All drivers
SQLGetInfo Access dBASE Paradox Text File Excel
SQLGetStmtOption All drivers
SQLGetTypeInfo Access dBASE Paradox Text File Excel
SQLMoreResults All drivers
SQLPrepare All drivers
SQLProcedureColumns Access
SQLProcedures All drivers
SQLSetConnectOption Access dBASE Paradox Text File Excel
SQLSetCursorName All drivers
SQLSetPos All drivers
SQLSetScrollOptions All drivers
SQLSetStmtOption All drivers
SQLSpecialColumns All drivers
SQLStatistics Access dBASE Paradox Text File Excel
SQLTables Access dBASE Paradox Text File Excel
SQLTransact Access dBASE Paradox Text File Excel

The following topics provide remarks about ODBC functions. These remarks apply to all ODBC Desktop Database Drivers.