Features of Release V8.1.7.1.0

sqora00000000.gifFeatures of Release 8.1.7.1.0

Features of the Oracle8 ODBC Driver Release 8.1.7.1.0 software for the Windows 95, Windows 98, Windows 2000, and Windows NT X86 operating systems are described as follows:

SQL_WCHAR Support

When this support is enabled, SQLDescribeCol returns the data type of SQL_WCHAR for SQL_CHAR columns; SQL_WVARCHAR for SQL_VARCHAR columns; and SQL_WLONGVARCHAR for SQL_LONGVARCHAR columns. This feature was added to enable Unicode support in applications which rely on the results of SQLDescribeCol (for example, ADO). This feature is enabled/disabled as a Datasource Configuration option. By default, it is disabled.

Support for SQL Server EXEC Syntax

A procedure (or function) call specified in an EXEC statement will be translated to its equivalent Oracle procedure (or function) call before being processed by the Oracle8 database server if this feature is enabled. This feature is managed as a Datasource Configuration option. By default, EXEC Syntax Support is disabled.

New Setup Dialog Box

The Setup Dialog Box has been re-engineered to more clearly organize the Datasource Configuration options.

TNS Name Integration

The Datasource Configuration setup now presents the list of TNS names already defined on the system.

Batch Autocommit Mode

The default behavior for the Oracle8 ODBC Driver is to rollback a transaction if there is a failure on any row. The default for the Oracle7 ODBC Driver is to commit up to the row that has a failure. Batch Autocommit Mode was added to make the Oracle8 ODBC Driver compatible with the Oracle7 ODBC Driver.

There is a third option which directs the ODBC driver to commit all rows which did not have an error. This third option is available only when connected to an Oracle8 database. Against earlier databases, this option is identical to the default Oracle7 behavior. The default remains to rollback the entire transaction.

E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy