Skip to content

Latest commit

 

History

History
70 lines (56 loc) · 9.44 KB

File metadata and controls

70 lines (56 loc) · 9.44 KB
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 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.