About this Manual

This document is written for the programmer developing a SQL interface to any data source to allow SQL access from PCs and other platforms using Microsoft OLE DB, ODBC, or .NET compliant interfaces or Sun Microsystems JDBC compliant interface.

This document provides detailed description of the steps involved in writing the code that works with our SQL engine (Database Access Manager).

Specifically, this document covers the following topics:

·          Product architecture

·          Database Access Manager (DAM) architecture

·          Developing an IP for a non-SQL database

·          Developing an IP for a data source capable of executing SQL statements

This document is divided into 9 major chapters.  Chapter 1 provides the Interface Provider (IP) programmer with overviews of the OpenAccess architecture and the features of the product.  Chapter 2 provides a guided tour of the operations performed by the DAM and an IP to execute SQL statements.  Chapter 3 details the development of drivers that require the use of the OpenAccess SQL engine.  Chapter 4 provides the details you will need to design and code your own IP.  Chapter 5 covers advanced topics such as Table Expression Pushdown.  Chapter 6 details the development of drivers working in SQL pass through mode.  Chapter 7 details the distributed transactions. Chapter 8 details internationalization.  Chapter 9 provides detailed information about the Windows Authentication feature as supported by OpenAccess.  Chapter 10 discusses the configuration to support fail over and load balancing.

Refer to the OpenAccess SDK Installation for details on installing the driver development kit.

Please refer to the OpenAccess SDK for C/C++ Programmer’s Reference for details on implementing a non-SQL IP in C/C++ and the details of the DAM API for C/C++.

Refer to the OpenAccess SDK Programmer’s Reference for Java for details on implementing a non-SQL IP in Java and the details of the DAM API for Java.

Refer to the OpenAccess SDK Programmer’s Reference for .NET for details on implementing a non-SQL IP in .NET and the details of the DAM API for .NET. Refer to the OpenAccess SQL Reference for complete coverage of the SQL supported by the OpenAccess SQL engine.

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.