--- title: "Supported ODBC API Functions | Microsoft Docs" ms.custom: "" ms.date: "01/19/2017" ms.prod: sql ms.prod_service: connectivity ms.reviewer: "" ms.technology: connectivity ms.topic: conceptual helpviewer_keywords: - "ODBC, API functions" - "ODBC SQL grammar, API functions mapped to driver (table) [ODBC]" ms.assetid: b28a8ed6-09b1-4acf-bf3e-f90bb32422de author: David-Engel ms.author: v-daenge --- # 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](../../odbc/reference/develop-app/conformance-levels.md) 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](../../odbc/reference/syntax/odbc-api-reference.md) section, under [ODBC Programmer's Reference](../../odbc/reference/odbc-programmer-s-reference.md). 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](../../odbc/reference/syntax/sqlbindparameter-function.md)|||||[Excel](../../odbc/microsoft/sqlbindparameter-excel-driver.md)|| |[SQLColAttributes](../../odbc/reference/syntax/sqlcolattributes-function.md)|[Access](../../odbc/microsoft/sqlcolattributes-access-driver.md)|[dBASE](../../odbc/microsoft/sqlcolattributes-dbase-driver.md)|[Paradox](../../odbc/microsoft/sqlcolattributes-paradox-driver.md)|[Text File](../../odbc/microsoft/sqlcolattributes-text-file-driver.md)|[Excel](../../odbc/microsoft/sqlcolattributes-excel-driver.md)|| |[SQLColumns](../../odbc/reference/syntax/sqlcolattributes-function.md)|[Access](../../odbc/microsoft/sqlcolattributes-access-driver.md)|[dBASE](../../odbc/microsoft/sqlcolattributes-dbase-driver.md)|[Paradox](../../odbc/microsoft/sqlcolattributes-paradox-driver.md)|[Text File](../../odbc/microsoft/sqlcolattributes-text-file-driver.md)|[Excel](../../odbc/microsoft/sqlcolattributes-excel-driver.md)|| |[SQLConfigDataSource](../../odbc/reference/syntax/sqlconfigdatasource-function.md)|[Access](../../odbc/microsoft/sqlconfigdatasource-access-driver.md)|[dBASE](../../odbc/microsoft/sqlconfigdatasource-dbase-driver.md)|[Paradox](../../odbc/microsoft/sqlconfigdatasource-paradox-driver.md)|[Text File](../../odbc/microsoft/sqlconfigdatasource-text-file-driver.md)|[Excel](../../odbc/microsoft/odbc-jet-sqlconfigdatasource-excel-driver.md)|| |[SQLDriverConnect](../../odbc/reference/syntax/sqldriverconnect-function.md)|[Access](../../odbc/microsoft/sqldriverconnect-access-driver.md)|[dBASE](../../odbc/microsoft/sqldriverconnect-dbase-driver.md)|[Paradox](../../odbc/microsoft/sqldriverconnect-paradox-driver.md)|[Text File](../../odbc/microsoft/sqldriverconnect-text-file-driver.md)|[Excel](../../odbc/microsoft/sqldriverconnect-excel-driver.md)|| |[SQLGetCursorName](../../odbc/reference/syntax/sqlgetcursorname-function.md)||||||[All drivers](../../odbc/microsoft/sqlgetcursorname-desktop-database-drivers.md)| |[SQLGetData](../../odbc/reference/syntax/sqlgetdata-function.md)||||||[All drivers](../../odbc/microsoft/sqlgetdata-desktop-database-drivers.md)| |[SQLGetInfo](../../odbc/reference/syntax/sqlgetinfo-function.md)|[Access](../../odbc/microsoft/sqlgetinfo-access-driver.md)|[dBASE](../../odbc/microsoft/sqlgetinfo-dbase-driver.md)|[Paradox](../../odbc/microsoft/sqlgetinfo-paradox-driver.md)|[Text File](../../odbc/microsoft/sqlgetinfo-text-file-driver.md)|[Excel](../../odbc/microsoft/sqlgetinfo-excel-driver.md)| |[SQLGetStmtOption](../../odbc/reference/syntax/sqlgetstmtoption-function.md)||||||[All drivers](../../odbc/microsoft/sqlgetstmtoption-desktop-database-drivers.md)| |[SQLGetTypeInfo](../../odbc/reference/syntax/sqlgettypeinfo-function.md)|[Access](../../odbc/microsoft/sqlgettypeinfo-access-driver.md)|[dBASE](../../odbc/microsoft/sqlgettypeinfo-dbase-driver.md)|[Paradox](../../odbc/microsoft/sqlgettypeinfo-paradox-driver.md)|[Text File](../../odbc/microsoft/sqlgettypeinfo-text-file-driver.md)|[Excel](../../odbc/microsoft/sqlgettypeinfo-excel-driver.md)|| |[SQLMoreResults](../../odbc/reference/syntax/sqlmoreresults-function.md)||||||[All drivers](../../odbc/microsoft/sqlmoreresults-desktop-database-drivers.md)| |[SQLPrepare](../../odbc/reference/syntax/sqlprepare-function.md)||||||[All drivers](../../odbc/microsoft/sqlprepare-desktop-database-drivers.md)| |[SQLProcedureColumns](../../odbc/reference/syntax/sqlprocedurecolumns-function.md)|[Access](../../odbc/microsoft/sqlprocedurecolumns-access-driver.md)|||||| |[SQLProcedures](../../odbc/reference/syntax/sqlprocedures-function.md)||||||[All drivers](../../odbc/microsoft/sqlprocedures-desktop-database-drivers.md)| |[SQLSetConnectOption](../../odbc/reference/syntax/sqlsetconnectoption-function.md)|[Access](../../odbc/microsoft/sqlsetconnectoption-access-driver.md)|[dBASE](../../odbc/microsoft/sqlsetconnectoption-dbase-driver.md)|[Paradox](../../odbc/microsoft/sqlsetconnectoption-paradox-driver.md)|[Text File](../../odbc/microsoft/sqlsetconnectoption-text-file-driver.md)|[Excel](../../odbc/microsoft/sqlsetconnectoption-excel-driver.md)|| |[SQLSetCursorName](../../odbc/reference/syntax/sqlsetcursorname-function.md)||||||[All drivers](../../odbc/microsoft/sqlsetcursorname-desktop-database-drivers.md)| |[SQLSetPos](../../odbc/reference/syntax/sqlsetpos-function.md)||||||[All drivers](../../odbc/microsoft/sqlsetpos-desktop-database-drivers.md)| |[SQLSetScrollOptions](../../odbc/reference/syntax/sqlsetscrolloptions-function.md)||||||[All drivers](../../odbc/microsoft/sqlsetscrolloptions-desktop-database-drivers.md)| |[SQLSetStmtOption](../../odbc/reference/syntax/sqlsetstmtoption-function.md)||||||[All drivers](../../odbc/microsoft/sqlsetstmtoption-desktop-database-drivers.md)| |[SQLSpecialColumns](../../odbc/reference/syntax/sqlspecialcolumns-function.md)||||||[All drivers](../../odbc/microsoft/sqlspecialcolumns-desktop-database-drivers.md)| |[SQLStatistics](../../odbc/reference/syntax/sqlstatistics-function.md)|[Access](../../odbc/microsoft/sqlstatistics-access-driver.md)|[dBASE](../../odbc/microsoft/sqlstatistics-dbase-driver.md)|[Paradox](../../odbc/microsoft/sqlstatistics-paradox-driver.md)|[Text File](../../odbc/microsoft/sqlstatistics-text-file-driver.md)|[Excel](../../odbc/microsoft/sqlstatistics-excel-driver.md)|| |[SQLTables](../../odbc/reference/syntax/sqltables-function.md)|[Access](../../odbc/microsoft/sqltables-access-driver.md)|[dBASE](../../odbc/microsoft/sqltables-dbase-driver.md)|[Paradox](../../odbc/microsoft/sqltables-paradox-driver.md)|[Text File](../../odbc/microsoft/sqltables-text-file-driver.md)|[Excel](../../odbc/microsoft/sqltables-excel-driver.md)| |[SQLTransact](../../odbc/reference/syntax/sqltransact-function.md)|[Access](../../odbc/microsoft/sqltransact-access-driver.md)|[dBASE](../../odbc/microsoft/sqltransact-dbase-driver.md)|[Paradox](../../odbc/microsoft/sqltransact-paradox-driver.md)|[Text File](../../odbc/microsoft/sqltransact-text-file-driver.md)|[Excel](../../odbc/microsoft/sqltransact-excel-driver.md)|| The following topics provide remarks about ODBC functions. These remarks apply to all ODBC Desktop Database Drivers. - [SQLGetData (Desktop Database Drivers)](../../odbc/microsoft/sqlgetdata-desktop-database-drivers.md) - [SQLGetStmtOption(Desktop Database Drivers)](../../odbc/microsoft/sqlgetstmtoption-desktop-database-drivers.md) - [SQLMoreResults (Desktop Database Drivers)](../../odbc/microsoft/sqlmoreresults-desktop-database-drivers.md) - [SQLPrepare (Desktop Database Drivers)](../../odbc/microsoft/sqlprepare-desktop-database-drivers.md) - [SQLProcedures (Desktop Database Drivers)](../../odbc/microsoft/sqlprocedures-desktop-database-drivers.md) - [SQLSetCursorName (Desktop Database Drivers)](../../odbc/microsoft/sqlsetcursorname-desktop-database-drivers.md) - [SQLSetPos (Desktop Database Drivers)](../../odbc/microsoft/sqlsetpos-desktop-database-drivers.md) - [SQLSetScrollOptions (Desktop Database Drivers)](../../odbc/microsoft/sqlsetscrolloptions-desktop-database-drivers.md) - [SQLSetStmtOption (Desktop Database Drivers)](../../odbc/microsoft/sqlsetstmtoption-desktop-database-drivers.md) - [SQLSpecialColumns (Desktop Database Drivers)](../../odbc/microsoft/sqlspecialcolumns-desktop-database-drivers.md)