What's New in Oracle Provider for OLE DB?

The following sections describe the new features in Oracle Provider for OLE DB (OraOLEDB):

• New Features in Oracle Provider for OLE DB for Release 10.1

• New Features in Oracle Provider for OLE DB for Release 9.2.0.4

• New Features in Oracle Provider for OLE DB for Release 9.2

• New Features in Oracle Provider for OLE DB for Release 9.0.1

• New Features in Oracle Provider for OLE DB for Release 8.1.7

New Features in Oracle Provider for OLE DB for Release 10.1

This section contains these topics:

• Support for Oracle Grids

  OraOLEDB is grid-enabled, allowing developers to take advantage of Oracle database grid support without having to make changes to their application code.

• Support for the following datatypes introduced with Oracle Database 10g:

  • BINARY_DOUBLE

  • BINARY_FLOAT

  
  

  See Also: "Datatypes" for descriptions of the new datatypes

  
  

• Support for Multiple Homes

  Oracle Provider for OLE DB can be installed in Multiple Oracle Homes, starting with release 10.1. However, being a COM component, only one instance can be active on the computer. This means that the current (latest) installation renders the previous one inactive.

  In order to make multiple homes available, some of the OraOLEDB files now include a version number, and the use of a HOMEID is required.

  
  

  See Also: Oracle Provider for OLE DB Files

  
  

New Features in Oracle Provider for OLE DB for Release 9.2.0.4

OraOLEDB release 9.2.0.4, which was released on Oracle Technology Network (OTN) included the following:

• OraOLEDB-Specific Connection String Attribute UseSessionFormat:

  UseSessionFormat specifies whether to use the default NLS session formats or let OraOLEDB override some of these formats for the duration of the session.

  
  

  See Also: "OraOLEDB-specific Connection String Attributes"

  
  

• Support for the following datatypes introduced with Oracle9i:

  • TIMESTAMP

  • TIMESTAMP WITH TIME ZONE

  • TIMESTAMP WITH LOCAL TIME ZONE

  • INTERVAL YEAR TO MONTH

  • INTERVAL DAY TO SECOND

  
  

  See Also: "Datatypes" for descriptions of the new datatypes

  
  

New Features in Oracle Provider for OLE DB for Release 9.2

This section contains these topics:

• Support for using OraOLEDB with OLE DB .NET Data Provider

  ADO.NET applications developers can use OraOLEDB through the OLE DB .NET Data Provider. A connection attribute, OLEDB.NET, can be set at connection time for OraOLEDB to be compatible with OLE DB .NET Data Provider.

  
  

  See Also: "OLE DB .NET Data Provider Compatibility"

  
  

New Features in Oracle Provider for OLE DB for Release 9.0.1

This section contains these topics:

• Using Oracle9i on Windows 2000

  There are some differences between using Oracle9i on Windows 2000 and Windows NT 4.0.

  
  

  See Also: Oracle Database Platform Guide for Windows

  
  

New Features in Oracle Provider for OLE DB for Release 8.1.7

Oracle8i release 8.1.7 included the following:

• Support for returning multiple rowsets.

  Consumers can use this feature to access all the REF CURSORs returned by a stored procedure.

  
  

  See Also: "Multiple Rowsets"

  
  

• Support for the Unicode character set.

  Using this feature, consumers can use OraOLEDB to access data in multiple languages on the same client computer. It can be especially useful in creating global Internet applications supporting as many languages as the Unicode standard entails. For example, one can write a single Active Server Page (ASP) that accesses an Oracle8i database to dynamically generate content in Japanese, Arabic, English, and Thai.

  
  

  See Also: "Unicode Support" "Datatype Mappings in Rowsets and Parameters"