Solved

Should I use ADODB, OLEDB or ADOX?

Posted on 2011-09-22
6
588 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
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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

911 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now