SQLGetFunctions (Extension Level 1)

  • Article

The SQLGetFunctions function is modified to indicate that the data source write operations are unsupported.

Note  For more information about support or requirements for installation on a specific operating system, see Operating System Availability of WMI Components.

This topic lists the supported and unsupported functions by level:

  • Core functions
  • Extended level 1 functions
  • Extended level 2 functions

Core Functions

The following SQLGetFunctions core functions are supported:

SQL_API_SQLALLOCCONNECT

SQL_API_SQLALLOCENV

SQL_API_SQLALLOCSTMT

SQL_API_SQLBINDCOL

SQL_API_SQLCANCEL

SQL_API_SQLCOLATTRIBUTES

SQL_API_SQLCONNECT

SQL_API_SQLDESCRIBECOL

SQL_API_SQLDISCONNECT

SQL_API_SQLERROR

SQL_API_SQLEXECDIRECT

SQL_API_SQLEXECUTE

SQL_API_SQLFETCH

SQL_API_SQLFREECONNECT

SQL_API_SQLFREEENV

SQL_API_SQLFREESTMT

SQL_API_SQLGETCURSORNAME

SQL_API_SQLNUMRESULTCOLUMNS

SQL_API_SQLPREPARE

SQL_API_SQLROWCOUNT

SQL_API_SQLSETCURSORNAME

The following SQLGetFunctions core functions are unsupported:

SQL_API_SQLSETPARAM

SQL_API_SQLTRANSACT

Extended Level 1 Functions

The following SQLGetFunctions extended level 1 functions are supported:

SQL_API_SQLBINDPARAMETER

SQL_API_SQLCOLUMNS

SQL_API_SQLDRIVERCONNECT

SQL_API_SQLGETCONNECTOPTION

SQL_API_SQLGETDATA

SQL_API_SQLGETFUNCTIONS

SQL_API_SQLGETINFO

SQL_API_SQLGETSTMTOPTION

SQL_API_SQLGETTYPEINFO

SQL_API_SQLPARAMDATA

SQL_API_SQLPUTDATA

SQL_API_SQLSETCONNECTOPTION

SQL_API_SQLSETSTMTOPTION

SQL_API_SQLSPECIALCOLUMNS

SQL_API_SQLSTATISTICS

SQL_API_SQLTABLES

Extended Level 2 Functions

The following SQLGetFunctions extended level 2 functions are supported:

SQL_API_DATASOURCES

SQL_API_DRIVERS

SQL_API_SQLMORERESULTS

The following SQLGetFunctions extended level 2 functions are unsupported:

SQL_API_SQLBROWSECONNECT

SQL_API_SQLCOLUMNPRIVILEGES

SQL_API_DESCRIBEPARAM

SQL_API_EXTENDEDFETCH

SQL_API_FOREIGNKEYS

SQL_API_SQLNATIVESQL

SQL_API_SQLNUMPARAMS

SQL_API_SQLPARAMOPTIONS

SQL_API_SQLPRIMARYKEYS

SQL_API_SQLPROCEDURECOLUMNS

SQL_API_SQLPROCEDURES

SQL_API_SQLSETPOS

SQL_API_SQLSETSCROLLOPTIONS

SQL_API_SQLTABLEPRIVILEGES