Difference Between OLEDB and ODBC
OLEDB vs ODBC
Both OLEDB and ODBC find relevant applications in Database Management Systems (DBMS). ODBC or Open Database Connectivity was developed by Microsoft as a low key strategic interface for accessing data. Catering to a heterogeneous mix of relational and non relational database management systems, ODBC offers an open, free – access to data stored on personal computers, mainframe computers, laptops and other computing devices and databases. Independent website developers, coders and vendors can use ODBC for getting a strong grip on interfaces which deal with multiple applications programming.
OLE DB, which stands for Object Linking and Embedding, Database, was also developed by Microsoft at a later point, and is used for accessing data from various databases. OLEDB is seen as a successor to ODBC in terms of extended functionality, more freedom in terms of data access and applications, and this is the major difference between OLEDB and ODBC. If you are using OLEDB or ODBC providers in order to import data from a database into Excel, then you should be aware of the different features offered by each, so that you work becomes easier and there are lesser mistakes involved. Each of them possesses unique properties and applications, and has their own limitations, and hence an acute understanding would help:
OLEDB does not retrieve one page field item at a time, whereas this is possible with ODBC.
Parameter Queries can be created with the help of ODBC, but not OLEDB
If a data source has been moved, reconnecting with it is possible with OLEDB, but not with ODBC.
OLEDB supports the creation of .odc extension files from Query or Pivot table, whereas OBBC does not.
Queries can be edited manually in OLEDB through a dialog box, whereas ODBC provides support through Query Table.
Search DifferenceBetween.net :
Email This Post : If you like this article or our site. Please spread the word. Share it with your friends/family.