What is difference between ODBC and OLEDB?
Sushil Kumar
Microsoft designed ODBC to access SQL data and OLE DB to access any type of data in a COM environment. In short...
ODBC is an open standard. OLE DB is a Microsoft solution ODBC provides access only to relational databases. OLE DB Access to data regardless of its format or location