Re: ADO

From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 02/12/05 

Date: Sat, 12 Feb 2005 20:31:34 +0100

Hi

ADO is the programming interface to ODBC, OLE DB etc. It is a layer above
the drivers, your assumption is correct.
It relies on the other components in the MDAC stack, plus data
driver/providers supplied by Microsoft and other vendors.

DAO was used mostly for Microsoft Access (and later SQL Server) and was the
first non direct API interface, then came RDO, then ADO and now ADO.NET.

All of the above 4 programming interfaces can communicate with ODBC and OLE
DB providers.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Hassan" <fatima_ja@hotmail.com> wrote in message
news:e397LgTEFHA.3120@TK2MSFTNGP12.phx.gbl...
> So is ADO just another data access component then ? And is it bundled with
> MDAC ?
>
> I thought ADO is a layer over ODBC or OLE DB and uses one of those
> components , but did not know it was another access component .
>
> "David Gugick" <davidg-nospam@imceda.com> wrote in message
> news:uU65JiNEFHA.548@TK2MSFTNGP14.phx.gbl...
> > Hassan wrote:
> > > Do front end apps have to use ADO to connect to SQL Server ? If not,
> > > what else can they use ? Just trying to get familiar with the
> > > terminology from a client portion of the code that uses SQL Server
> >
> > ADO.Net, ADO, ODBC, RDO, dbLib, and so on.
> >
> > If you're writing an application in .Net, use the native SQL Server
> > driver. ADO and ODBC are good options as well.
> >
> >
> > --
> > David Gugick
> > Imceda Software
> > www.imceda.com
> >
>
>

Relevant Pages

  • RE: Connection from ASP- ODBC vs. SQLOLEDB
    ... script, ADO is preferable. ... ODBC is an API for database access that's both a formal and a de facto ... call-level interface standard by American National Standards Institute ... OLE DB ...
    (microsoft.public.sqlserver.server)
  • Re: TADO vs. TQuery
    ... >> I have an application that uses ODBC to connect to MS SQL ... >> this benefit greatly if I changed to ADO? ... It will take a while to 'tune up' ADO objects to get BDE speed. ... Eventually we started using DOA (Direct ...
    (borland.public.delphi.database.ado)
  • Re: Problem updating a record containing a negative Value
    ... If it is the same in ADO or ADO.NET then this is definitely a bug in ODBC ... driver from the vendor. ...
    (microsoft.public.data.ado)
  • Re: Geschwindigkeit von ADO
    ... nur um das noch mal klar zu stellen: Man kann/darf ADO nicht mit ODBC ... Datenzugriffsmechanismen stecken im OLE DB bzw. ODBC Treiber. ... Fall mit einem ADO Objekt zugreifen. ...
    (microsoft.public.de.fox)
  • Re: ADO Connection problem when not logged in as an Admin
    ... I never said that there was a difference between ODBC ADO and OLEDB ADO. ... Provider for ODBC) that can make the connection between ADO and an ODBC ...
    (microsoft.public.access.modulesdaovba)