Re: Regarding Database Connection

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


<chintu4uin@xxxxxxxxx> wrote in message
news:1142916157.098993.307850@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi I m new to programming please help me.

How many types Database connectivity are there using ADO and give
examples of each to understand it.
Is this are the type of Database connectivity
1)Connection String
2)ODBC..

Please help me......


Your terminology is a bit off.

All data access is based on a series of layers of 'access' from software to
the data store. ADO or ActiveX Data Objects is a Data Access Library which,
based on MS's concept of Universal Data Access can 'access' a variety of
data stores using a common object model.

Classic ADO uses OLE DB (COM) providers. MS's latest version of ADO, ADO.Net
uses 'managed providers' which present a similar interface as OLE DB. But as
far as ADO is concerned that is where the 'layer' stops.

Various data stores can supply various kinds of providers or drivers - Jet,
ODBC, CLI, ... (odbc itself is a specification not any one implementation),
so you could have a cartisian product of 'connectivity' schemes. For
example, You could have for an Oracle database the following...
The Oracle CLI engine -> ODBC driver -> OLE DB/ODBC provider -> ADOclassic.
But this would be rather silly as it would be best to use...
The Oracle CLI engine -> Oracle OLE DB provider -> ADO.

Providers themselves can be initiatialized with a variety of means
(connection strings, DSN, UDLs, iNet, ...)

So each of your 'connectivites' actually represents just one piece of the
multiple layers and how they might be implemented.

hth
-ralph


.

Relevant Pages

  • Re: Need some advice on ADO .NET
    ... William (Bill) Vaughn ... .NET and am coming from a different background (PowerBuilder)? ... As the other folks have said, ADO.NET is an ... >> data access to a variety of backend data access servers and ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO
    ... OLE DB is a data access paradigm designed to provide an object interface to ... OLE DB data "providers". ... The original question asked which is better: ADO or OLE DB. ...
    (microsoft.public.data.ado)
  • Re: Data access layer for SQL Server & MS Access
    ... Just use ADO; that's my vote. ... RobinS wrote: ... You need to create a custom "Data Access Class" that obscures the type ... Could I not just avoid this and use OLEDB for both database types? ...
    (microsoft.public.dotnet.languages.vb)
  • implementing ADO
    ... website looking for ADO download and as they say in Iowa.. ... think this is a conspiracy heh heh:) ... ActiveX Data Objects ... Microsoft Data Access Components ...
    (borland.public.delphi.database.ado)
  • Re: Recommended Reading/Self tuition
    ... start looking at ADO but reading some threads it seems that whilst this has ... "What is ADO? ... ActiveX Data Objects is a simple data access technology that can ... developers are forever grasping at concepts. ...
    (comp.databases.ms-access)