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

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-03-2013, 10:53 PM   #1
AlejandroGG
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

Hi,

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?

Thanks.

AlejandroGG is offline   Reply With Quote
Old 10-03-2013, 11:18 PM   #2
Galaxiom
Super Moderator
 
Join Date: Jan 2009
Location: NSW Australia
Posts: 11,093
Thanks: 68
Thanked 1,371 Times in 1,293 Posts
Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold
Re: Best class to access database

Microsoft encouraged OLEDB for several years but now they are going back to ODBC and dropping OLEDB support in future releases of SQL Server.
Galaxiom is online now   Reply With Quote
Reply

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 01:55 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


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