Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ADO or ODBC Client Side Access to Oracle 8.1?

Re: ADO or ODBC Client Side Access to Oracle 8.1?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 14 Oct 2001 15:27:36 +0200
Message-ID: <tsj4to6jetme63@corp.supernews.com>

"Marc Allen" <marc.allen4_at_verizon.net> wrote in message news:wbgy7.666$k65.25229_at_typhoon1.gnilink.net...
> I have the option of client side access of using ADO or ODBC for client
side
> access to Oracle 8.1. There is no legacy code to comply with and the
client
> is running Win 2000. I am developing in C++ with MFC so the MFC database
> classes are available. I have hooked up the Oracle db both with test apps
> using ADO and ODBC without any problems.
> The client database access will involve about 20 to 30 tables that is
being
> created and there is no legacy tables to be in sync with.
> My question is - is there a prefered client side access to Oracle 8.1
either
> by Oracle or db developers?
>
> Thanks,
>
> Marc
>
>
>

Oracle Objects for OLE is the only *native* solution providing and Access ?DAO like interface to Oracle, and supports array fetching. ODBC runs on top of the native Oracle driver, so it will always be slower. OO4O comes with the Oracle client.

Hth,

Sybrand Bakker
Senior Oracle DBA Received on Sun Oct 14 2001 - 08:27:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US