Introduction to CUBRID Manual 
API Reference 
ODBC Overview Versions available for this page: CUBRID 8.2.1 | CUBRID 8.3.0 | CUBRID 8.3.1 | CUBRID 8.4.0 | CUBRID 8.4.1 | CUBRID 8.4.3 | CUBRID 9.0.0 |
ODBC API
For ODBC API, see ODBC API Reference (http://msdn.microsoft.com/en-us/library/windows/desktop/ms714562%28v=vs.85%29.aspx) on the MSDN page. See the table below to get information about the list of functions, ODBC Spec version, and compatibility that CUBRID supports.
|
API |
Version Introduced |
Standards Compliance |
Support |
|---|---|---|---|
|
SQLAllocHandle |
3.0 |
ISO 92 |
YES |
|
SQLBindCol |
1.0 |
ISO 92 |
YES |
|
SQLBindParameter |
2.0 |
ODBC |
YES |
|
SQLBrowseConnect |
1.0 |
ODBC |
NO |
|
SQLBulkOperations |
3.0 |
ODBC |
YES |
|
SQLCancel |
1.0 |
ISO 92 |
YES |
|
SQLCloseCursor |
3.0 |
ISO 92 |
YES |
|
SQLColAttribute |
3.0 |
ISO 92 |
YES |
|
SQLColumnPrivileges |
1.0 |
ODBC |
NO |
|
SQLColumns |
1.0 |
X/Open |
YES |
|
SQLConnect |
1.0 |
ISO 92 |
YES |
|
SQLCopyDesc |
3.0 |
ISO 92 |
YES |
|
SQLDescribeCol |
1.0 |
ISO 92 |
YES |
|
SQLDescribeParam |
1.0 |
ODBC |
NO |
|
SQLDisconnect |
1.0 |
ISO 92 |
YES |
|
SQLDriverConnect |
1.0 |
ODBC |
YES |
|
SQLEndTran |
3.0 |
ISO 92 |
YES |
|
SQLExecDirect |
1.0 |
ISO 92 |
YES |
|
SQLExecute |
1.0 |
ISO 92 |
YES |
|
SQLFetch |
1.0 |
ISO 92 |
YES |
|
SQLFetchScroll |
3.0 |
ISO 92 |
YES |
|
SQLForeignKeys |
1.0 |
ODBC |
YES (2008 R3.1 or later) |
|
SQLFreeHandle |
3.0 |
ISO 92 |
YES |
|
SQLFreeStmt |
1.0 |
ISO 92 |
YES |
|
SQLGetConnectAttr |
3.0 |
ISO 92 |
YES |
|
SQLGetCursorName |
1.0 |
ISO 92 |
YES |
|
SQLGetData |
1.0 |
ISO 92 |
YES |
|
SQLGetDescField |
3.0 |
ISO 92 |
YES |
|
SQLGetDescRec |
3.0 |
ISO 92 |
YES |
|
SQLGetDiagField |
3.0 |
ISO 92 |
YES |
|
SQLGetDiagRec |
3.0 |
ISO 92 |
YES |
|
SQLGetEnvAttr |
3.0 |
ISO 92 |
YES |
|
SQLGetFunctions |
1.0 |
ISO 92 |
YES |
|
SQLGetInfo |
1.0 |
ISO 92 |
YES |
|
SQLGetStmtAttr |
3.0 |
ISO 92 |
YES |
|
SQLGetTypeInfo |
1.0 |
ISO 92 |
YES |
|
SQLMoreResults |
1.0 |
ODBC |
YES |
|
SQLNativeSql |
1.0 |
ODBC |
YES |
|
SQLNumParams |
1.0 |
ISO 92 |
YES |
|
SQLNumResultCols |
1.0 |
ISO 92 |
YES |
|
SQLParamData |
1.0 |
ISO 92 |
YES |
|
SQLPrepare |
1.0 |
ISO 92 |
YES |
|
SQLPrimaryKeys |
1.0 |
ODBC |
YES (2008 R3.1 or later) |
|
SQLProcedureColumns |
1.0 |
ODBC |
YES (2008 R3.1 or later) |
|
SQLProcedures |
1.0 |
ODBC |
YES (2008 R3.1 or later) |
|
SQLPutData |
1.0 |
ISO 92 |
YES |
|
SQLRowCount |
1.0 |
ISO 92 |
YES |
|
SQLSetConnectAttr |
3.0 |
ISO 92 |
YES |
|
SQLSetCursorName |
1.0 |
ISO 92 |
YES |
|
SQLSetDescField |
3.0 |
ISO 92 |
YES |
|
SQLSetDescRec |
3.0 |
ISO 92 |
YES |
|
SQLSetEnvAttr |
3.0 |
ISO 92 |
NO |
|
SQLSetPos |
1.0 |
ODBC |
YES |
|
SQLSetStmtAttr |
3.0 |
ISO 92 |
YES |
|
SQLSpecialColumns |
1.0 |
X/Open |
YES |
|
SQLStatistics |
1.0 |
ISO 92 |
YES |
|
SQLTablePrivileges |
1.0 |
ODBC |
YES (2008 R3.1 or later) |
|
SQLTables |
1.0 |
X/Open |
YES |
Backward compatibility is not supported for some CUBRID functions. Refer to information in the mapping table below to change unsupported functions into appropriate ones.
|
ODBC 2.x Functions |
ODBC 3.x Functions |
|---|---|
|
SQLAllocConnect |
SQLAllocHandle |
|
SQLAllocEnv |
SQLAllocHandle |
|
SQLAllocStmt |
SQLAllocHandle |
|
SQLBindParam |
SQLBindParameter |
|
SQLColAttributes |
SQLColAttribute |
|
SQLError |
SQLGetDiagRec |
|
SQLFreeConnect |
SQLFreeHandle |
|
SQLFreeEnv |
SQLFreeHandle |
|
SQLFreeStmt with SQL_DROP |
SQLFreeHandle |
|
SQLGetConnectOption |
SQLGetConnectAttr |
|
SQLGetStmtOption |
SQLGetStmtAttr |
|
SQLParamOptions |
SQLSetStmtAttr |
|
SQLSetConnectOption |
SQLSetConnectAttr |
|
SQLSetParam |
SQLBindParameter |
|
SQLSetScrollOption |
SQLSetStmtAttr |
|
SQLSetStmtOption |
SQLSetStmtAttr |
|
SQLTransact |
SQLEndTran |
Note To get the latest information about ODBC driver, click http://www.cubrid.org/wiki_apis/entry/cubrid-odbc-driver.