Easysoft ODBC-JDBC Gateway ODBC Conformance
The Easysoft ODBC-JDBC Gateway supports the following ODBC functions:
- SQLAllocHandle
- SQLAllocEnv
- SQLBindCol
- SQLBindParameter
- SQLCancel
- SQLCloseCursor
- SQLColAttribute
- SQLColAttributes
- SQLColumnPrivileges
- SQLColumns
- SQLConnect
- SQLDescribeCol
- SQLDisconnect
- SQLDriverConnect
- SQLEndTran
- SQLExecDirect
- SQLExecute
- SQLExtendedFetch
- SQLFetch
- SQLFetchScroll
- SQLForeignKeys
- SQLFreeHandle
- SQLFreeStmt
- SQLGetConnectAttr
- SQLGetCursorName
- SQLGetData
- SQLGetDescField
- SQLGetDescRec
- SQLGetDiagField
- SQLGetDiagRec
- SQLGetEnvAttr
- SQLGetFunctions
- SQLGetInfo
- SQLGetStmtAttr
- SQLGetTypeInfo
- SQLMoreResults
- SQLNativeSql
- SQLNumResultCols
- SQLParamData
- SQLPrepare
- SQLPrimaryKeys
- SQLProcedures
- SQLProcedureColumns
- SQLPutData
- SQLRowCount
- SQLSetConnectAttr
- SQLSetCursorName
- SQLSetDescField
- SQLSetDescRec
- SQLSetEnvAttr
- SQLSetStmtAttr
- SQLSpecialColumns
- SQLStatistics
- SQLTables
- SQLTablePrivileges
If available, the Easysoft ODBC-JDBC Gateway supports the Unicode version (with suffix "W") of the ODBC calls it implements. The Easysoft ODBC-JDBC Gateway supports:
- SQLColAttributeW
- SQLColAttributesW
- SQLColumnPrivilegesW
- SQLColumnsW
- SQLConnectW
- SQLDescribeColW
- SQLDriverConnectW
- SQLExecDirectW
- SQLForeignKeysW
- SQLGetConnectAttrW
- SQLGetCursorNameW
- SQLGetDescFieldW
- SQLGetDescRecW
- SQLGetDiagFieldW
- SQLGetDiagRecW
- SQLGetInfoW
- SQLGetStmtAttrW
- SQLGetTypeInfoW
- SQLNativeSqlW
- SQLPrepareW
- SQLPrimaryKeysW
- SQLProcedureColumnsW
- SQLProceduresW
- SQLSetConnectAttrW
- SQLSetCursorNameW
- SQLSetDescFieldW
- SQLSetStmtAttrW
- SQLSpecialColumnsW
- SQLStatisticsW
- SQLTablePrivilegesW
- SQLTablesW
The following ODBC functions are not supported in the current version of the Easysoft ODBC-JDBC Gateway:
- SQLBrowseConnect
- SQLBulkOperations
- SQLCopyDesc
- SQLDescribeParam
- SQLNumParams
- SQLSetPos
- SQLSetScrollOptions (deprecated in ODBC 3)
Parameter based calls are not currently available, because the underlying support for them is not available in JDBC 2. This may change in later versions of the Easysoft ODBC-JDBC Gateway when JDBC 3 drivers become more common.