Difference between Sql Connection and OLEDB Connection

sql sqlconnection oledbconnection
Abdul Rahman picture Abdul Rahman · Aug 20, 2011 · Viewed 23.4k times · Source

What is the difference between the SQL Connection and OLEDB Connection? Is that OLEDB is common to all (also SQL Server)? To which are all Servers, OLEDB is using?

Answer

Naga Harish M picture Naga Harish M · Aug 20, 2011

The advantage of using OleDbConnection is flexibility. You can change your database (for instance, move to Oracle)and not have to change your code.

If you using SQLServer as backend then use SQLConnection for better performance.

check with this link http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/fadb2742-d75a-49fb-a839-b2d4a9183998/

OleDbConnection : You can connect to any database, which you have provide for that.

Tip: use Universal Data Link File

enter image description here

Related questions

How to use the ConfigurationManager.AppSettings

I've never used the "appSettings" before. How do you configure this in C# to use with a SqlConnection, this is what I use for the "ConnectionStrings" SqlConnection con = new SqlConnection(); con.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; And this is what …

Read More
"Login failed for user" C# with SQLConnection

I've been trying to connect to my database (which is on the same computer as my code) through my C# code. The problem is I keep getting the "Login failed for user " "" error... I admit that my knowledge of connecting …

Read More
Most efficient way to test SQL connection string availibility

I have this code down which I tried to make it Test SQL string connectivity, but I dont know how to handle the part with connection.Open = true would you please help me to solve this out? Thank you so …

Read More