Oracle Objects for OLE 2.3 for Download

[Quoted] [Quoted] Oracle Objects for OLE 2.3 (Trial version) is available for download from the following sites

Minimal:

ftp://external-ftp.us.oracle.com/dev_tools/outgoing/oo4o/win32/23runtime/

Full:

http://www.oracle.com/products/trial/html/trial.html

The new features introduced in V2.3 are

1. Support of Database connection pooling ( for ASP application)
2. Performance improvement in Dynaset field access
3. Reduced network roundtrip for executing Dynaset's SQL statement
4. More bug fixes

Here is the short description for Oracle Objects for OLE

Oracle Objects For OLE (OO4O) is a product designed to allow easy access to [Quoted] data stored in Oracle databases from any programming or scripting language [Quoted] that supports the Microsoft COM Automation and ActiveX technology. This includes Visual Basic, Visual C++, Visual Basic For Applications (VBA), IIS [Quoted] Active Server Pages (VBScript and JavaScript), and others.

The OO4O Automation Server is a set of COM Automation objects for connecting to Oracle database servers, executing SQL statements and PL/SQL blocks, and [Quoted] accessing the results.

Unlike other COM-based database connectivity APIs, such as Microsoft ADO, the OO4O Automation Server has been developed and evolved specifically for [Quoted] use with Oracle database servers. It provides an optimized API for accessing [Quoted] features that are unique to Oracle and are otherwise cumbersome or inefficient to use from ODBC or OLE DB-based components.

OO4O provides key features for efficiently and easily accessing Oracle databases in environments ranging from the typical two-tier client/server applications (developed in Visual Basic or Excel, for example) to application servers deployed in application server environments such as web [Quoted] server applications in Microsoft Internet Information Server (IIS). Features include:

[Quoted]
• Support for execution of PL/SQL anonymous blocks and stored procedures. This includes support for for all data types allowed for input/output parameters of PL/SQL stored procedures incluing PL/SQL cursors.
  • Free threaded objects and connection pooling for developing efficient web server applications [Quoted]
  • Support for array inserts and updates << link to description of SQLStmt and Parameter interfaces