Go Back   Access World Forums > Apps and Windows > VB.NET

Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 10-03-2013, 10:53 PM   #1
Newly Registered User
Join Date: Oct 2013
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
AlejandroGG is on a distinguished road
Best class to access database


I will create a visual basic .net 2010 application that needs to be independent of the type of database. Specifically databases are access and sql server 2008.

Therefore, need a class that can access multiple database types. I have read that there are two classes that do this: OdbcConnection and OleDbConnection

What class is best to use in a matter of performance? OdbcConnection or OleDbConnection?

I have read that it is better to use OdbcConnection but I'm not sure.

Is there much difference in performance compared to native classes like SqlConnection?


AlejandroGG is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Employee Training database class assignment robina Tables 4 07-23-2012 08:52 AM
Need help implementing property of base class in derived class. papadilbert Modules & VBA 6 12-01-2011 06:11 AM
Correct syntax to make Class Function Private yet callable by instances of Class mdlueck Modules & VBA 4 11-07-2011 07:32 AM
Using a VB6 Class File with Access M_S_Jones Modules & VBA 1 06-16-2009 11:25 AM
database Class Brian Martin General 2 01-17-2003 08:52 AM

All times are GMT -8. The time now is 06:47 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World