Re: ODBC vs. OO4O Help!!!

I would use OO40 if possible:

It uses SqlNet directly without the overhead of the ODBC layer.....

It is fully Oracle compliant - that is, it can do anything an Oracle connection can do....

Its much faster than even the best ODBC ( at least in my experience )

It is easier to write the supporting VB code.....

Downside :

Users must have the necessary files to use it....

The VB IDE doesn't always 'prompt' for the operators/methods for the Oracle Objects like it can do for 'native' VB stuff....

All in all, I'd go with OO40----

John Greco
Oracle DBA/Application Developer
Email to john.greco_at_dot.state.mn.us

"ibm news" <albert_at_comtec.co.il> wrote:

>Hi!
>I have doubts to use ODBC or OO4O in VB app.
>Can anybody suggest me:
>1. which method has better reaction time
>2. advantages and disadvanteges of both methods
>3. a functionality missing in ODBC if any
>4. a functionality missing in OO4O if any
>
>About my VB app.
>1. Only DML not DDL
>2. Db size 10G
>3. Reaction time is critical
>4. Uses stored procedures
>5. 300 users
>
>Thank you in advance.
>Albert
>
>My EMail albert_at_comtec.co.il
>
>
Received on Thu Jul 30 1998 - 20:37:04 CEST