Re: ADO with Oracle

From: <cGraham_at_p01.on09.honeywell.com>
Date: Thu, 07 Jan 1999 16:22:38 GMT
Message-ID: <772n09$sv$1@nnrp1.dejanews.com>

In article <3693df84.34081546_at_newshost.us.oracle.com>,   jkallman_at_us.oracle.com (Joel R. Kallman) wrote:
> On Wed, 06 Jan 1999 16:28:04 GMT, cGraham_at_p01.on09.honeywell.com
> wrote:
>
> >What is the state of ADO with Oracle? Is there native ADO support for Oracle
> >from Windows NT, or is the Oracle ADO support implemented only via ODBC ? If
> >it's ODBC, what is Oracle's timeframe for native ADO support ? I went to
> >www.oracle.com, searched for "ADO", and came away with the impression that
> >there is no native support and that Oracle might be slow in providing it in
> >order to better sell their own COM object which they say is better than ADO.
>
> Microsoft let's you use ADO against SQL Server using:
>
> 1) ODBC: OLE DB Provider for ODBC
> 2) Native: SQL Server OLE DB Provider
>
> Oracle let's you use ADO against Oracle using:
>
> 1) ODBC: OLE DB Provide for ODBC
> 2) Native: Oracle Objects for OLE
>
> All you need to do is read the postings of others in this newsgroup to
> get their feedback about the performance and features of Oracle
> Objects for OLE. Oracle provided this native support (i.e., not using
> ODBC) long before there was an ADO, RDO, OLE DB Provider, etc.
>
> BTW, Oracle Objects for OLE is shipped/bundled with all flavors of
> Oracle servers for Windows (except Oracle Lite), Programmer for
> Windows, and Intel Client CD. This includes a development license.
> Thanks!
>
> Joel
>
> Joel R. Kallman
> Oracle Service Industries
> Columbus, OH
> jkallman@us.oracle.com http://www.oracle.com
>
> ----
> The statements and opinions expressed here are my own
> and do not necessarily represent those of Oracle Corporation.
>

Thank you very much for your reply.

The options seem to be:

1. OO4O
2. ODBC
3. ADO

OO4O would be very performant for accessing Oracle but it would seem to deny the flexibility for using other databases. Oracle seems to be the Rolls Royce of databases but the flexibility is definately a must nevertheless. It is desirable to maintain options for exploiting the economic advantages of diverse databases, as well their technical merits, for comprehensive and optimal solutions in diverse economic and technical circumstances.

ODBC would be more performant and (and possibly more reliable) if there is no native ADO support. I've since learned that there seems to be native Microsoft ADO support, for Oracle, after all; although I couldn't tell that from www.microsoft.com. Indeed, there's an article on www.microsoft.com, dated in 1999, that talks about "when native Oracle ADO will be released."

ADO would definately be the superior choice, without question, if good native ADO support is available. Microsoft seems to be abandoning ODBC for ADO. In my mind, only performance can recommend ODBC over ADO as things stand now; and native ADO seems to be more performant than ODBC.

What are peoples' experiences with using Microsoft's native Oracle ADO ?

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Jan 07 1999 - 10:22:38 CST