Which one is best?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ram_palavalasa - 21 Apr 2006 04:19 GMT

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 i
VC++.Net?

Thanks,
Ram..:

--
ram_palavalas

Reply to this Message

Carl Daniel [VC++ MVP] - 21 Apr 2006 05:48 GMT

> 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?

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

Reply to this Message

ram_palavalasa - 21 Apr 2006 06:57 GMT

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

'Carl Daniel [VC++ MVP Wrote:

> Best for whom? In what context? Used for what kind of access? Ove
> which
[quoted text clipped - 10 lines]
>
> -c

--
ram_palavalas

Reply to this Message

Carl Daniel [VC++ MVP] - 21 Apr 2006 15:21 GMT

> I have a assignment of vc++.net and sybase to populate data and
> generate reports which is the best one?

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.

> is OLEDB more efficient than ODBC?i think OLEDB itself is a layer on
> the ODBC..then how it can be?

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

Reply to this Message

Which one is best?

Free Magazines