1. Introduction#
This chapter introduces the Altibase ODBC driver.
Introduction#
ODBC(Open Database Connectivity) is a standard programming language interface accessing databases, which is developed by Microsoft. In order that ODBC Application developed using ODBC API accesses a database, a specific module or driver(e.g., ODBC Driver Manager) the database providing is required. Altibase provides the Altibase ODBC driver, which conforms to ODBC 3.51 specifications, for this purpose.
As the Altibase ODBC driver is built upon Altibase CLI, you can refer to the Altibase CLI User's Manual for more detailed information on the internal procedures of the Altibase ODBC driver or for more specific description.
Data Type#
For more detailed information on on the mapping relationship between SQL data type and ODBC data type supported by Altibase, please refer to "B. Appendix: Data Types" in Altibase CLI User's Manual.
ODBC API#
For more detailed further information on the ODBC API, please refer to the ODBC API Reference.
ODBC Conformance Level#
Based on the conformance of ODBC functions, this section describes three types of functions: those that are currently supported for Altibase ODBC, those that are soon to be supported, and those that are not supported.
The purpose of specify the ODBC conformance level is to provide to the application, in- formation of which functionality of the ODBC driver to use. ODBC conformance is currently categorized into the three levels: Core, Level 1 and Level 2. To satisfy the conformance level of a function, the driver must meet all the conditions required for that level.
The following table shows the conformance level of the ODBC 3.x standard. This is different from the confromance level of ODBC 2.x; Level 1 for ODBC 2.x can be seen here as a core.
The Altibase ODBC driver conforms to ODBC 3.51 specifications. The following table shows the conformance level of each ODBC function, and whether the Altibase ODBC driver is supported or not.
| Function Name | Levels | Support Status | Future Support | Remarks |
|---|---|---|---|---|
| SQLAllocHandle | Core | O | ||
| SQLBindCol | Core | O | ||
| SQLBindParameter | Core | O | ||
| SQLBrowseConnect | Level1 | X | X | |
| SQLBulkOperations | Level1 | O | ||
| SQLCancel | Core | O | ||
| SQLCloseCursor | Core | O | ||
| SQLColAttribute | Core | O | ||
| SQLColumnPrivileges | Level2 | X | X | Columns are not supported by Altibase |
| SQLColumns | Core | O | ||
| SQLConnect | Core | O | ||
| SQLCopyDesc | Core | X | O | |
| SQLDescribeCol | Core | O | ||
| SQLDescribeParam | Level2 | O | Not fully supported. | |
| SQLDisconnect | Core | O | ||
| SQLDriverConnect | Core | O | ||
| SQLEndTran | Core | O | ||
| SQLExecDirect | Core | O | ||
| SQLExecute | Core | O | ||
| SQLFetch | Core | O | ||
| SQLFetchScroll | Core | O | ||
| SQLForeignKeys | Level2 | O | ||
| SQLFreeHandle | Core | O | ||
| SQLFreeStmt | Core | O | ||
| SQLGetConnectAttr | Core | O | ||
| SQLGetCursorName | Core | O | ||
| SQLGetData | Core | O | ||
| SQLGetDescField | Core | O | ODBC 3.0 | |
| SQLGetDescRec | Core | O | ODBC 3.0 | |
| SQLGetDiagField | Core | O | ODBC 3.0 | |
| SQLGetDiagRec | Core | O | ODBC 3.0 | |
| SQLGetEnvAttr | Core | O | ||
| SQLGetFunctions | Core | O | ||
| SQLGetInfo | Core | O | ||
| SQLGetStmtAttr | Core | O | ||
| SQLGetTypeInfo | Core | O | ||
| SQLMoreResults | Level1 | O | ||
| SQLNativeSql | Core | O | ||
| SQLNumParams | Core | O | ||
| SQLNumResultCols | Core | O | ||
| SQLParamData | Core | O | ||
| SQLPrepare | Core | O | ||
| SQLPrimaryKeys | Level1 | O | ||
| SQLProcedureColumns | Level1 | O | ||
| SQLProcedures | Level1 | O | ||
| SQLPutData | Core | O | ||
| SQLRowCount | Core | O | ||
| SQLSetConnectAttr | Core | O | ||
| SQLSetCursorName | Core | O | ||
| SQLSetDescField | Core | O | ODBC 3.0 | |
| SQLSetDescRec | Core | O | ODBC 3.0 | |
| SQLSetEnvAttr | Core | O | ||
| SQLSetPos | Level1 | O | ||
| SQLSetStmtAttr | Core | O | ||
| SQLSpecialColumns | Core | O | ||
| SQLStatistics | Core | O | ||
| SQLTablePrivileges | Level2 | O | ||
| SQLTables | Core | O |