Difference Between Similar Terms and Objects

Difference Between OLEDB and 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 :

Custom Search

Help us improve. Rate this post! 1 Star2 Stars3 Stars4 Stars5 Stars

Email This Post Email This Post : If you like this article or our site. Please spread the word. Share it with your friends/family.

Leave a Response

Please note: comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.

Articles on DifferenceBetween.net are general information, and are not intended to substitute for professional advice. The information is "AS IS", "WITH ALL FAULTS". User assumes all risk of use, damage, or injury. You agree that we have no liability for any damages.

See more about :
Protected by Copyscape Plagiarism Finder