Difference between OLE DB and ODBC?

ODBC (Open Data Base Connectivity) 

• It is a connection method with data source.
• It requires to set up a data source, or what is call DSN (Database Source Name) using a SQL Driver or other drivers if connecting to other database types.
• Most database systems support ODBC.
• ODBC provides access only to relational databases.

OLE DB (Object Linking and Embedding Database) 

• It is a successor of ODBC.
• Access to data regardless of its format or location i.e. access the data in uniform manner.
• OLE DB does not require a DSN.
• OLE DB provides full access to ODBC data sources and ODBC drivers.
• In many cases the OLE DB components offer much better performance than the older ODBC.
• OLE DB provides access to relational and non-relational databases.