About this Manual

This document contains the details for the programmer who wants to implement an ODBC, OLE DB, JDBC, or .NET compliant driver to a SQL compliant database management system. 

This document provides detailed description of the steps involved in writing an adapter to integrate a SQL capable engine into OpenAccess in order to allow the use of standard APIs that include ODBC, JDBC, OLE DB, and .NET.  Specifically, this document covers the following topics:

·          Developing an IP for a SQL database

·          SQL IP API for C/C++ – the functions your adapter written in C or C++ must implement

·          SQL IP API for Java – the interfaces and associated methods your adapter written in Java must implement.

·          Exposing the schema

·          Example Interface

Notation Convention

The courier font is used for system-dependent keywords and commands to be typed by the user.  The pipe character ‘|’ is used as a shortcut notation and separator between menus, sub-menus, and items.  As an example:  ‘File | Open’ means the Open option from the File menu.

Getting Technical Support

Technical support is available by telephone and Email.  Please provide the OpenAccess product version and the platform you are running on when calling/writing for technical support.