Features and Benefits for Release 3.0 of the Easysoft ODBC-Oracle Driver

With the release of Easysoft ODBC-Oracle Driver version 3.0, Easysoft have created a new standard for ODBC connectivity to the Oracle database. This document describes the additional features added since our last major release of the driver, and discusses the benefits that these features bring to the user.

• Performance
• Oracle Feature Support
• Installer
• Data Type Support
• New API Calls
• New SQL Features
• Fixes to Problems

Performance

While the driver was previously one of the quickest available, we have improved the performance of the driver such that the fetching of data may now be 300% faster. This performance increase has been gained by analysis of typical use patterns and subsequent optimisation of the Oracle API calls. No additional changes are required to existing application code to take advantage of this extra performance, and there are no potential hidden costs to slow down other operations.

Further details about the magnitude of this improvement can be found in this document.

Oracle Feature Support

Additional support has been added for the following Oracle features:

• Now fully supports Instant Client libraries including version 10.1 and 10.2.

  Both the Easysoft ODBC-Oracle Driver and its support tools are Instant Client aware. The driver will work seamlessly with both the full Oracle client installation and the new Instant Client installation. The driver may be set to use a full client by the use of the ORACLE_HOME environment setting. An Instant Client-only connection may use the new connection string format (//host:port/sid). A mixed mode connection may also be used, employing the TNS_ADMIN environment setting to enable the use of a tnsnames.ora file with the Instant Client.

  The support tools provided with the driver let you check the configuration and will suggest possible problems and their solution.

• Fully supports the new Oracle Database XE release.

  This is discussed in the document Accessing Oracle Database XE by using the Easysoft ODBC-Oracle Driver.

• Fully supports Oracle Advanced Security features, including authentication, validation and encryption.
• Integrates with Transaction Monitors for Oracle XA Distributed transaction support.

  This is discussed in the document Easysoft ODBC-Oracle Driver XA Support.

Installer

The following changes have been made to the Unix installation:

• The Easysoft ODBC-Oracle Driver now supports non root installations.

  The software can be installed in any location through the use of EASYSOFT_ROOT environment variable. This allows the full installation of a local copy of the driver to be done without needing access to the root account. A test installation can therefore be done without affecting the full production installation.

• Quicker

  The installation process has been streamlined to remove unnecessary user interaction.

• Instant Client aware

  The installer will use the appropriate format for the database string if the use of a Instant Client connection is detected.

Data Type Support

The following additional data types are supported:

• TIMESTAMP_TZ

  This is a "TIMESTAMP WITH TIME ZONE" type, and it is mapped to an ODBC SQL_TYPE_TIMESTAMP.

• TIMESTAMP_LTZ

  This is a "TIMESTAMP WITH LOCAL TIME ZONE" type, and it is also mapped to an ODBC SQL_TYPE_TIMESTAMP.

• BIGINT

  If an Oracle column is defined as a NUMERIC type with a zero scale and a precision greater than 19 (the maximum that can fit into an ODBC SQLINTEGER type), the Easysoft ODBC-Oracle Driver will map this as an SQL_BIGINT.

New API Calls

Support has been added in the driver for the following ODBC API calls:

• SQLBrowseConnect
• SQLBulkOperations
• SQLCopyDesc

New SQL Features

Positioned updates and deletes can now be done using "SELECT ... FOR UPDATE OF" statements.

Fixes to Problems

Over 40 minor problems have been fixed in this release. These are detailed in the CHANGES.txt file included in the installation.