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.