Difference between Sql Connection and OLEDB Connection – This article will take you through the common SQL errors that you might encounter while working with sql, sqlconnection, oledbconnection. The wrong arrangement of keywords will certainly cause an error, but wrongly arranged commands may also be an issue. SQL keyword errors occur when one of the words that the SQL query language reserves for its commands and clauses is misspelled. If the user wants to resolve all these reported errors, without finding the original one, what started as a simple typo, becomes a much bigger problem.
SQL Problem :
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?
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
SqlConnection is designed to access SQL Server, while OleDbConnection is designed to access any database.
Finding SQL syntax errors can be complicated, but there are some tips on how to make it a bit easier. Using the aforementioned Error List helps in a great way. It allows the user to check for errors while still writing the project, and avoid later searching through thousands lines of code.