?
Solved

Should I use ADODB, OLEDB or ADOX?

Posted on 2011-09-22
6
Medium Priority
?
703 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 1000 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 65

Assisted Solution

by:rockiroads
rockiroads earned 1000 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 learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Suggested Courses

752 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