> Minimal:

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

> 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
> data stored in Oracle databases from any programming or scripting language
> that supports the Microsoft COM Automation and ActiveX technology. This
> includes Visual Basic, Visual C++, Visual Basic For Applications (VBA), IIS
> 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
> 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
> use with Oracle database servers. It provides an optimized API for accessing
> 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
> server applications in Microsoft Internet Information Server (IIS). Features
> include:

>     - 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
>    -  Support for array inserts and updates << link to description of
> SQLStmt and Parameter interfaces

>1) Does this require any other oracle server products other than the
standard NT
>oracle database running? i.e. does it need something like Oracle Web
server?

>2) Will this be a cost item in the future? If so what price range?

>> 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/23runt...

>> 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
>> data stored in Oracle databases from any programming or scripting
language
>> that supports the Microsoft COM Automation and ActiveX technology. This
>> includes Visual Basic, Visual C++, Visual Basic For Applications (VBA),
IIS
>> 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
>> 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
>> use with Oracle database servers. It provides an optimized API for
accessing
>> 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
>> server applications in Microsoft Internet Information Server (IIS).
Features
>> include:

>>     - 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
>>    -  Support for array inserts and updates << link to description of
>> SQLStmt and Parameter interfaces

> John Timney

> >Has anyone used OO4O ? I'd be interested in your experiences. Thanks,