Which method of accessing an oracle database is faster and more flexible;
using Oracle Objects for OLE or accessing the database through ODBC using
SQLPASSTHROUGH queries.

Blair.

I only used OO4O with VB3.  In comparing it with ODBC it was literally
about 10 times faster.  It wasn't as flexible, but the speed way outweighed
the flexibility.
--
Lance King
Work: 770-801-4502

Take out "nospam." to send message.

Oracle Object is by far the faster data access. This method is
also easy to implement.

I found the opposite - OO4O was 25 times slower than using RDO and ODBC,
and also gave us great problems with international issues (Apparently OO4O
can only speak american).

You should use OO4O V2.1 which also includes a new data control.
The connect time to the database is much faster compared to ODBC, also the
data access if you avoid object references as described in the OO4O help
file programming hints.

Roger

http://members.aol.com/zuehlsdorf/index.html

===================================================