473,545 Members | 1,863 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Which one is best?


Hi all,

Whichone is the best among the following while proessing the data?
ODBC,DAO,ADO,OL EDB...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 1609
ram_palavalasa wrote:
Hi all,

Whichone is the best among the following while proessing the data?
ODBC,DAO,ADO,OL EDB...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
4214
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 to develop the application for my end users. Should I use Java or MS.Net technology or should I mix both of them ? Basically, I have these...
1
4111
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 hardware takes over and copies the other drive over to mirror it again. However, my sql server admin book, says raid 1 is bad, as it means you have...
3
1380
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 way. In the constructor i have created the connection instant in the following way
17
3946
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 http://forta.com/books/0672325667/
34
10771
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 VBA code that wrote the results of that away to the db, either creating new records or updating existing records, whichever was relevant. This may...
24
2838
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 abilities by writing my own nice editor with python; so I've to choose among all those GUI toolkit's available there.. But I've no idea which one I...
16
1821
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. def p(self, paragraph):
5
2642
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 various option like login, password, organism to view , select perticular option etc., and the backend as postgresql where all the process of submission...
103
6781
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)? These are just a sample of nasty quicksand web pages I've run into which lock your browser into a loop and won't let you get out until you hit the...
0
7487
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7680
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7446
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6003
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
4966
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3476
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3459
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1033
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
731
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.