All geek questions in one place

Difference between Sql connection and OLEDB connection

What is the difference between an SQL connection and an OLEDB connection? Is OLEDB shared by all (also SQL Server)? Which servers do all OLEDB use?

+6
source share
2 answers

The advantage of using OleDbConnection is flexibility. You can change your database (for example, switch to Oracle) and not change the code.

If you are using SQLServer as your backend, use SQLConnection to improve 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 that you have provided for this.

Tip: Use Universal File Transfer

enter image description here

+10
source

SqlConnection is designed to access SQL Server, and OleDbConnection is designed to access any database.

+5
source

Source: https://habr.com/ru/post/895476/

More articles:


All Articles