Wednesday 24 April 2013

What is difference between ODBC and Provider in C#.Net

ODBC :

  • ODBC Stands for Open Database Connectivity.
  • To Communicate with remote Databases Microsoft has designed ODBC drivers which facilitates the process of communication with Remote Databases.
OLEDB providers :
  • OleDB Stands for Object linking and embedding database)
  • These are designed purely for DataSource communication and more over a provider sits on the Server machine. So all the clients can use the provider to communicate with the datasource without installing them on client machine.

No comments:

Post a Comment