Free Download
Links
Glossary
White Papers
SQL-99 Textbook
Company Info
SQL Tutorial
BOOK REVIEWS:
SQL Books
DBMS Books
JDBC Books
ADO Books
MySQL Books
Sybase Books
Informix Books
DB2 Books
Home
Get a free copy of our DBMS
Order our book
|
Compatibility of THE OCELOT SQL DBMS with ODBC 3.0
THE OCELOT SQL DBMS includes an API which has the same
function names, and accepts the same parameters, as required by Microsoft's
ODBC specification -- but behaviour may differ. So we say "supports ODBC
syntax" but not "is ODBC compatible". As part of the download, you will
find some example files (named SAMPLE?.C) which exemplify uses of
core-level ODBC function calls. You can test out our driver's functionality
with (e.g.) Ken North's ODBC benchmark tests, which can be downloaded from
the DDJ forum. We have connected with common front-end utilities like
MSQuery, DBExplore, and WinSQL. Another example: you can call
THE OCELOT SQL DBMS from Borland/Inprise Delphi
(32-bit) using ODBC 3.0; we were able to do this successfully with Delphi's
"TQuery" and "TDBNavigator" and "TDBGrid" controls.
The calls which Ocelot's driver (to some extent) supports are:
SQLAllocConnect,
SQLAllocEnv,
SQLAllocHandle,
SQLAllocStmt,
SQLBindCol,
SQLCancel,
SQLCloseCursor,
SQLColAttribute,
SQLColumns,
SQLConnect,
SQLDescribeCol,
SQLDisconnect,
SQLEndTran,
SQLError,
SQLExecDirect,
SQLExecute,
SQLFetch,
SQLFetchScroll,
SQLForeignKeys,
SQLFreeConnect,
SQLFreeEnv,
SQLFreeHandle,
SQLFreeStmt,
SQLGetConnectAttr,
SQLGetCursorName,
SQLGetData,
SQLGetDiagField,
SQLGetDiagRec,
SQLGetEnvAttr,
SQLGetFunctions,
SQLGetInfo,
SQLGetStmtAttr,
SQLGetTypeInfo,
SQLNumResultCols,
SQLPrepare,
SQLPrimaryKeys,
SQLRowCount,
SQLSetConnectAttr,
SQLSetCursorName,
SQLSetEnvAttr,
SQLSetParam,
SQLSetStmtAttr,
SQLTables,
SQLTransact.
The same calls are used in non-ODBC environments -- Ocelot does not have a
separate proprietary API. The only difference in a non-ODBC environment
is that the henv or hdbc or hstmt handles all have a fixed value (minus 1).
Copyright (c) 2000-2003 by Ocelot Computer Services Inc. All rights reserved.
Return to Ocelot home page
|