Solved

Should I use ADODB, OLEDB or ADOX?

Posted on 2011-09-22
6
661 Views
Last Modified: 2012-05-12
Dear experts,

I am writing a C# Windows form program to integrate some data from Access databases. A lot of INSERT and UPDATE will be made. What is the best way to establish the database connection, ADODB, OLEDB, ADOX? Thanks in advance.
0
Comment
Question by:quziguang
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 15

Accepted Solution

by:
Minh Võ Công earned 250 total points
ID: 36584689
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36584856
Define "Integrate" in terms of exactly what you will be doing.

I think I see more ADO than anything else..
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 36584865
I reckon either ado.net or oledb would be good enough. I am not sure but I did read somewhere ado.net slightly slower but don't quote me on that.

some alternatives to throw at you. Have a look at linq (though I don't think there is much out there for msaccess) and if u want to hide more of the coding, nhibernate though it probably not worth it if you are just doing some updates
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 65

Assisted Solution

by:rockiroads
rockiroads earned 250 total points
ID: 36584873
0
 

Author Closing Comment

by:quziguang
ID: 36586000
Thanks to all for answering.
I'd like to accept both minhvc and rockiroads' answers. It looks like OLE DB is the one to use.
0
 
LVL 58
ID: 36586372

 All are the same thing.   OLEDB is a data provider, ADO a consumer.  ADOX is ADO extentions for security, etc., which you may not need.

 In short, you'll be using ADO, which will talk to the JET OLDEDB provider.

Jim.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question