Introduction

Overview

A SourcePro DB installation consists of the DB Interface Module and one or more DB Access Modules. Each DB Access Module provides access to a specific database API; this architecture is explained in detail in the DB Interface Module User's Guide.

The DB Access Module for ODBC provides access to ODBC drivers, using the Microsoft ODBC 3.x API.

 

This section provides technical information specifically related to the DB Access Module for ODBC . It supplements the generic information found in the DB Interface Module User's Guide and the SourcePro API Reference, which are not specific to databases. For information on building the DB Access Module s and your SourcePro DB applications, please see RCB: Installing and Building SourcePro and Rogue Wave Component Builder (RCB): Building Your Applications.

The ODBC SDK defines the notion of an ODBC Conformance Level for both the ODBC API and the ODBC SQL grammar. Driver vendors are free to implement only as much advanced functionality as they deem appropriate or possible. When we designed the DB Access Module for ODBC, we were confronted with the task of reconciling a wide range of possible driver capabilities. We chose not to write to the “lowest common denominator” as defined by the lowest level of ODBC conformance. We also resisted simulating certain behavior not directly supported by the driver (for example, nested transactions). Instead, we chose the most natural elements defined in the ODBC API and ODBC SQL grammar to implement as much of the functionality declared in the DB Interface Module as possible.

Functionality may vary considerably between ODBC drivers. Applications should be tested against the ODBC driver or drivers that they expect to use at installation sites.