473,386 Members | 1,720 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

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

Apr 21 '06 #1
3 1598
ram_palavalasa wrote:
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
Apr 21 '06 #2

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:
']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

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

Apr 21 '06 #3
ram_palavalasa wrote:
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
Apr 21 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: CY FOK | last post by:
Hi I am planning to open a software company to develop client-server apps and web applications for my client. Now, i am in a difficult situation to determine what is the best platform i should use...
1
by: JJ | last post by:
Hi, I was going to buy a server with Raid 1 as I thought that it meant that if one of the two mirrored drives fail, you simply take it out and put a new one in. At which point presumably the...
3
by: Balaji Kannan | last post by:
Hi, In dot net during component development i have used some member variables in the class file. Inside the class i have used the member declaration and the instant handling in the following...
17
by: clintonG | last post by:
I'm using an .aspx tool I found at but as nice as the interface is I think I need to consider using others. Some can generate C# I understand. Your preferences please... <%= Clinton Gallagher ...
34
by: Jeff | last post by:
For years I have been using VBA extensively for updating data to tables after processing. By this I mean if I had to do some intensive processing that resulted in data in temp tables, I would have...
24
by: invitro81 | last post by:
Hello I've recently learnt python and I do love it! I congratulate all those geeks who produce this nice language; well, because I could be called a nearby newbee I've decided to improve my...
16
by: John Salerno | last post by:
My initial feeling is that concatenation might take longer than substitution, but that it is also easier to read: def p(self, paragraph): self.source += '<p>' + paragraph + '</p>\n\n' vs. ...
5
nehashri
by: nehashri | last post by:
hi can ne1 plz guide me as to which interface is best for posgresql. i have started using posgrsql recently. i am making a biological database which has a frontend allowing the user to select...
103
by: Tom | last post by:
How do we get out of the browser infinite loop quicksand when we navigate to web pages designed to lock us in and force us to hit the "pay me" button (whatever they want to force you to do)? ...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.