Documentation

ODBC Driver Guide

Previous Topic

Next Topic

Supported Functions

The c-treeSQL ODBC Driver supports all Core and Level 1 API functions, and most Level 2 functions. Here is a complete list of the functions the driver supports. Applications can request this same information through the SQLGetFunctions() function with a FunctionId of SQL_API_ODBC3_ALL_FUNCTIONS.

SQLAllocConnect()
(Deprecated in ODBC 3.0)

SQLAllocEnv()
(Deprecated in ODBC 3.0)

SQLAllocHandle()

SQLAllocStmt()
(Deprecated in ODBC 3.0)

SQLBindCol()

SQLBindParam()
(Deprecated in ODBC 3.0)

SQLBindParameter()

Binds a buffer to a parameter marker in a SQL statement. SQLBindParameter() has 10 parameters. Parameter 4 and 5 change the way the date field is handled with reference to TPE_DFLT_DATE.

  • ValueType [Input] The C date type of the parameter
  • ParameterType [Input] The SQL data type of the parameter

When date is specified using a character string by setting ValueType to SQL_C_CHAR, the C data type of the parameter, the date formats supported are as follows:

When ParameterType is set to SQL_CHAR and TPE_DFLT_DATE is set to ISO_DFLT_DATE, the date formats supported is only YYYY-MM-DD and also the same format with ‘/’ as separator.

When ParameterType is set to SQL_TYPE_DATE and TPE_DFLT_DATE is set to ISO_DFLT_DATE, the date formats supported are MM-DD-YYYY, YYYY-MM-DD and DD-MON-YYYY and also the same formats with ‘/’ as the separator.

SQLBrowseConnect()

SQLCancel()

SQLCloseCursor()

SQLColAttribute()

SQLColAttributes()
(Deprecated in ODBC 3.0)

SQLColumnPrivileges()

SQLColumnPrivileges()
(Deprecated in ODBC 3.0)

SQLColumns()

SQLConnect()

SQLCopyDesc()

SQLDataSources()

SQLDescribeCol()

SQLDescribeParam()

SQLDisconnect()

SQLDriverConnect()

SQLDrivers()

SQLEndTran()

SQLError()
(Deprecated in ODBC 3.0)

SQLExecDirect()

SQLExecute()

SQLExtendedFetch()
(Deprecated in ODBC 3.0)

SQLFetch()

SQLFetchScroll()

SQLForeignKeys()

SQLFreeConnect()
(Deprecated in ODBC 3.0)

SQLFreeEnv()
(Deprecated in ODBC 3.0)

SQLFreeHandle()

SQLFreeStmt()
(Deprecated in ODBC 3.0)

SQLGetConnectAttr()

SQLGetConnectOption()
(Deprecated in ODBC 3.0)

SQLGetCursorName()

SQLGetData()

SQLGetDescField()

SQLGetDescRec()

SQLGetDiagField()

SQLGetDiagRec()

SQLGetEnvAttr()

SQLGetFunctions()

SQLGetInfo()

SQLGetStmtAttr()

SQLGetStmtOption()
(Deprecated in ODBC 3.0)

SQLGetTypeInfo()

SQLMoreResults()

SQLNativeSqlW()

SQLNumParams()

SQLNumResultCols()

SQLParamData()

SQLParamOptions()
(Deprecated in ODBC 3.0)

SQLPrepare()

SQLPrimaryKeys()

SQLProcedureColumns()

SQLProcedures()

SQLPutData()

SQLRowCount()

SQLSetConnectAttr()

SQLSetConnectOption()
(Deprecated in ODBC 3.0)

SQLSetCursorName()

SQLSetDescField()

SQLSetDescRec()

SQLSetEnvAttr()

SQLSetParam()
(Deprecated in ODBC 3.0)

SQLSetScrollOptions()

SQLSetStmtAttr()

SQLSetStmtOption()
(Deprecated in ODBC 3.0)

SQLSpecialColumns()

SQLStatistics()

SQLTablePrivileges()

SQLTables()

SQLTransact()
(Deprecated in ODBC 3.0)

TOCIndex