Re: Table adapter ???




"Marty" <radiolandog@xxxxxxxxxxxxx> wrote in message
news:eoaVUXNuHHA.484@xxxxxxxxxxxxxxxxxxxxxxx
What distingushes "classic ADO" from ADO.net?

Classic ADO is independent of .NET technology, it does not need it.
ADO (and ADOX, ADOMD) was a lightweight COM layer built on top of OLE DB.
So all it requires is COM support from Windows, nothing else.

With the Connection, Recordset and Command object, it made access to data
easy.
ADO and OLE DB updates came in downloads of the MDAC pack (Microsoft Data
Access Components).
MDAC came with Native providers (OLE DB speak for "drivers") for OLE DB, in
particular SQL Server, Oracle & Access (later deprecated).
It also came with a OLE DB provider for ODBC (also deprecated) which meant
that if all you had was a ODBC driver for some unusual database, you could
use this "piggyback" provider to get to your data.

A full history of MDAC is here
http://en.wikipedia.org/wiki/Microsoft_Data_Access_Components

ADO history is also here
http://msdn2.microsoft.com/en-us/library/ms676506.aspx

ADO.NET is a component of .NET, part of the Microsoft .NET Framework
In contrast to ADO, it has no Recordset object but a DataAdapter and
DataReader objects
I dont beleive you can use ADO.NET outside of a .NET.
See here
http://msdn2.microsoft.com/en-us/library/e80y5yhx.aspx
http://en.wikipedia.org/wiki/Ado.net

Stephen Howe


.



Relevant Pages

  • Re: Regarding fastest database interaction with Oracle in VC++
    ... If you are using ADO, then you will have a Connection object. ... is a lightweight COM API that sits on top of OLEDB. ... If you install MDAC 2.8, it will install some providers for you. ... It will install the MS Oracle provider. ...
    (microsoft.public.vc.database)
  • Re: Unbekannter Fehler mit dem SQL Server OLE DB Provider
    ... > ADO 2.8 und den OLE DB Provider verwenden. ... Next by Date: ...
    (microsoft.public.de.sqlserver)
  • Re: Recommended data access model
    ... This is from MDAC 2.8 SDK. ... "The Role of ADO in MDAC ... The Microsoft Data Access Components provide data access that is ... easy-to-use interface to OLE DB. ...
    (comp.databases.ms-access)
  • Re: MySQL via OLE DB
    ... But I could not find an OLE DB Provider for MySQL. ... no OLE DB provider for use with ADO. ... Does anybody know where I can download an OLE DB Provider for MySQL 5? ...
    (borland.public.delphi.database.ado)
  • Is it possible to use ADO in threaded service app?
    ... I have declared ADO DB connection and query for each thread, ... -When I use as ole provider Microsoft Jet 4.0 (for storing data use Access ...
    (borland.public.delphi.database.ado)