Download Tutorial Reviews Textbook Glossary
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