Re: Complete Beginner's question

Tech-Archive recommends: Fix windows errors by optimizing your registry



DAO is primarily intended for the older versions of Access -- consider it DOA (Dead On Arrival) now.
MFC classes for it survive because they still work, and some people would get upset if they were
removed.

Microsoft OLE DB:
http://msdn2.microsoft.com/en-us/library/ms722784.aspx

Microsoft Open Database Connectivity (ODBC) Start Page (Microsoft Open Database Connectivity
(ODBC)):
http://msdn.microsoft.com/library/en-us/odbc/htm/dasdkodbcoverview.asp?frame=true

Microsoft Active X Data Objects (ADO):
http://msdn.microsoft.com/library/en-us/ado270/htm/dasdkadooverview.asp?frame=true

ADO.NET:
http://msdn2.microsoft.com/en-us/library/e80y5yhx.aspx

You will need to choose from these based on a number of factors:
* Which programming language you're using (C++ and MFC?).
* Whether you are creating a managed (.NET) application or not.
* Whether you need lightweight code or easier-to-write code.
* Whether or not your database of choice has a driver or provider for the desired interface.
* Your preference.

"Jacky" <jl@xxxxxxxxxx> wrote in message news:uuAOwjiYHHA.992@xxxxxxxxxxxxxxxxxxxxxxx
Hi,
I wonder what are the differences between DAO, OLE DB and ODBC?
and the .NET versions of these?
How come MFC doesn't support OLE DB? But also why do MS keep DAO if the technology is obsolete?
What are ADO and ADO.NET? seems a lot of technologies that look so daunting!!
Thanks


.



Relevant Pages

  • Re: Zugriff auf Datenbank
    ... Eigentlich sollst Du diese Frage doch in eine Access Gruppe ... da DAO allein spezifisch für *.mdb (Jet ... Alternativ könntest Du OLE DB benutzen (falls Du den ... > End Sub ...
    (microsoft.public.de.word.vba)
  • Re: PocketPC
    ... SQL-PassThrough über ODBC / OLE DB ... Create Database XXX ... Ansonsten könnte es evtl. ... auch über die DAO gehen. ...
    (microsoft.public.de.fox)
  • Microsoft database technologies
    ... And what are all the DB programming paradigms available? ... Like DAO, ADO and OLE DB. ...
    (microsoft.public.data.oledb)
  • Re: newbie - easy sql select statement
    ... > I did not know that - never really did too much programming in DAO ... > Veign's Resource Center ... >> Actually, it's the OLE DB provider that forces the ...
    (microsoft.public.vb.general.discussion)