Re: ODBC vs. OO4O Help!!!
Date: Fri, 7 Aug 1998 13:15:55 +0100
Message-ID: <24C3919081C7D011957F08000038434770A5CF_at_ip3-99.nildram.co.uk>
I would agree. I have used it since it went Beta for VB3 back in 1994 and it got better and functionally richer over time.
-----Original Message-----
From: johng_at_mm.com (TurkBear) [mailto:johng_at_mm.com]
Posted At: Thursday, July 30, 1998 7:37 PM
Posted To: tools
Conversation: ODBC vs. OO4O Help!!!
Subject: 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 Fri Aug 07 1998 - 14:15:55 CEST