Which one is best?

Hi all,

Whichone is the best among the following while proessing the data?
ODBC,DAO,ADO,OLEDB...please justify urself why ?
also let me know how to loas dll component to the workspace in
VC++.Net?



Thanks,
Ram..:)


--
ram_palavalasa
------------------------------------------------------------------------
ram_palavalasa's Profile: http://www.hightechtalks.com/m320
View this thread: http://www.hightechtalks.com/t365309

re: Which one is best?

ram_palavalasa wrote:[color=blue]
> Hi all,
>
> Whichone is the best among the following while proessing the data?
> ODBC,DAO,ADO,OLEDB...please justify urself why ?
> also let me know how to loas dll component to the workspace in
> VC++.Net?[/color]

Best for whom? In what context? Used for what kind of access? Over which
database(s)? How big is the data? How expert are the developers?

Generally -

ODBC is the most portable
DAO is dead
ADO is the easiest (ADO.NET even easier)
OLE-DB is the most performant (ADO.NET a near tie - maybe better in some
cases)

-cd

re: Which one is best?

I have a assignment of vc++.net and sybase to populate data and generate
reports which is the best one?
is OLEDB more efficient than ODBC?i think OLEDB itself is a layer on
the ODBC..then how it can be?



'Carl Daniel [VC++ MVP Wrote:[color=blue]
> ']ram_palavalasa wrote:
>
> Best for whom? In what context? Used for what kind of access? Over
> which
> database(s)? How big is the data? How expert are the developers?
>
> Generally -
>
> ODBC is the most portable
> DAO is dead
> ADO is the easiest (ADO.NET even easier)
> OLE-DB is the most performant (ADO.NET a near tie - maybe better in
> some
> cases)
>
> -cd[/color]


--
ram_palavalasa
------------------------------------------------------------------------
ram_palavalasa's Profile: http://www.hightechtalks.com/m320
View this thread: http://www.hightechtalks.com/t365309

re: Which one is best?

ram_palavalasa wrote:[color=blue]
> I have a assignment of vc++.net and sybase to populate data and
> generate reports which is the best one?[/color]

Best in what way? Each has it's strengths and weaknesses.

ODBC - portable but tedious
OLE-DB - performant but complex
ADO - easy but less efficient

If what you need is reports, your best bet would be to forget about trying
to implement them in C++ and use a reporting tool such as SQL Server
reporting services (which can report on data in non-SQL server stores) or
Crystal Reports, or many others.
[color=blue]
> is OLEDB more efficient than ODBC?i think OLEDB itself is a layer on
> the ODBC..then how it can be?[/color]

OLE DB is not a layer on ODBC, although it can be. There's an OLE-DB
provider that adapts any ODBC data source, but generally OLE-DB providers
directly access the underlying data (e.g. for SQL Server, Sybase, Oracle at
least).

-cd