{"id":1396,"date":"2010-12-05T13:18:50","date_gmt":"2010-12-05T07:48:50","guid":{"rendered":"http:\/\/JitendraZaa.com\/blog\/?p=1396"},"modified":"2010-12-05T13:18:50","modified_gmt":"2010-12-05T07:48:50","slug":"what-is-odbc-and-oledb-interview-question","status":"publish","type":"post","link":"https:\/\/www.jitendrazaa.com\/blog\/microsoft\/what-is-odbc-and-oledb-interview-question\/","title":{"rendered":"What is ODBC and OLEDB – Interview Question"},"content":{"rendered":"

Open Database Connectivity (ODBC) :<\/strong><\/p>\n

<\/strong><\/p>\n

\"How<\/a>
How ODBC Works<\/figcaption><\/figure>\n

In computing, Open Database Connectivity (ODBC)<\/em> provides a standard software interface for accessing database management systems (DBMS)<\/strong>. The designers of ODBC aimed to make it independent of programming languages, database systems, and operating systems. Thus, any application can use ODBC to query data from a database, regardless of the platform it is on or DBMS it uses.<\/p>\n

<\/p>\n

ODBC provides a standard software API method for accessing both relational and non-relational DBMS. It was developed by the SQL Access Group<\/strong> in 1992 in order to facilitate easier communication between applications and databases across computing platforms. Prior to its creation, if an application needed the ability to communicate with more than a single database, it would have to support and maintain an interface for each. ODBC provides a universal middleware layer between the application and DBMS, allowing the application developers to only have to learn a single interface, nor do they have to update their software if changes are made to the DBMS specification, only the driver needs updating<\/span><\/strong>.<\/p>\n

Object Linking and Embedding, Database (OLE DB):<\/strong><\/p>\n

<\/strong><\/p>\n

\"What<\/a>
What is OLEDB<\/figcaption><\/figure>\n

OLE DB (Object Linking and Embedding, Database) <\/em>is an API designed by Microsoft for accessing data from a variety of sources in a uniform manner. It is a set of interfaces implemented using the Component Object Model (COM)<\/strong>. It was designed as a higher-level replacement for, and successor to, ODBC<\/strong>, extending its feature set to support a wider variety of non-relational databases, such as object databases and spreadsheets, powerpoint<\/span><\/strong> that do not necessarily implement SQL.<\/p>\n

OLE DB separates the data store from the application that needs access to it through a set of abstractions that include the datasource, session, command and rowsets. This was done because different applications need access to different types and sources of data and do not necessarily want to know how to access functionality with technology-specific methods. OLE DB is conceptually divided into consumers and providers<\/strong>. The consumers are the applications that need access to the data, and the provider is the software component that implements the interface and therefore provides the data to the consumer.<\/p>\n","protected":false},"excerpt":{"rendered":"

This articles explains in detail description of ODBC and OLEDB component of Microsoft and its Usage<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"jz_research_post":"","_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[22,5,14],"tags":[43,51,292],"class_list":["post-1396","post","type-post","status-publish","format-standard","hentry","category-csharp","category-microsoft","category-sqlserver","tag-asp-net","tag-c","tag-sql-server"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":936,"url":"https:\/\/www.jitendrazaa.com\/blog\/java\/jdbc-example-with-microsoft-access-in-swing\/","url_meta":{"origin":1396,"position":0},"title":"JDBC Example with Microsoft Access in Swing, Next and Previous navigation","author":"Jitendra","date":"August 31, 2010","format":false,"excerpt":"JDBC - Java Database Connectivity example in Swing","rel":"","context":"In "JAVA"","block_context":{"text":"JAVA","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/java\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1092,"url":"https:\/\/www.jitendrazaa.com\/blog\/others\/rtm-nu\/be-6th-sem-it-syllabus-of-rtmnu-nagpur-university-information-technology\/","url_meta":{"origin":1396,"position":1},"title":"BE 6th sem IT syllabus of RTMNU (Nagpur university – Information Technology)","author":"Jitendra","date":"September 15, 2010","format":false,"excerpt":"BE 6th sem IT syllabus of RTMNU (Nagpur university - Information Technology)","rel":"","context":"In "RTM NU"","block_context":{"text":"RTM NU","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/others\/rtm-nu\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1101,"url":"https:\/\/www.jitendrazaa.com\/blog\/others\/rtm-nu\/be-8th-sem-it-syllabus-of-rtmnu-nagpur-university-information-technology\/","url_meta":{"origin":1396,"position":2},"title":"BE 8th sem IT syllabus of RTMNU (Nagpur university – Information Technology)","author":"Jitendra","date":"September 15, 2010","format":false,"excerpt":"BE 8th sem IT syllabus of RTMNU (Nagpur university - Information Technology)","rel":"","context":"In "RTM NU"","block_context":{"text":"RTM NU","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/others\/rtm-nu\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2320,"url":"https:\/\/www.jitendrazaa.com\/blog\/others\/rtm-nu\/be-8th-sem-cse-syllabus-of-rtm-nagpur-university\/","url_meta":{"origin":1396,"position":3},"title":"BE 8th sem CSE syllabus of RTM Nagpur University","author":"Jitendra","date":"August 3, 2011","format":false,"excerpt":"BE 8th sem CSE syllabus of RTM Nagpur University","rel":"","context":"In "RTM NU"","block_context":{"text":"RTM NU","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/others\/rtm-nu\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1359,"url":"https:\/\/www.jitendrazaa.com\/blog\/sql\/sqlserverintegrationservices\/etl-dts-and-ssis-introduction\/","url_meta":{"origin":1396,"position":4},"title":"ETL , DTS and SSIS Introduction","author":"Jitendra","date":"December 4, 2010","format":false,"excerpt":"Introduction to ETL Services, Data transformation services, SQL Server Integration Services, Advantages of SSIS over DTS, New features of SSIS 2008","rel":"","context":"In "SSIS"","block_context":{"text":"SSIS","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/sql\/sqlserverintegrationservices\/"},"img":{"alt_text":"What is ETL Extraction Transformation Loading","src":"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/12\/What-is-ETL-Extraction-Transformation-Loading.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1184,"url":"https:\/\/www.jitendrazaa.com\/blog\/sql\/sqlserver\/manually-attach-database-in-sql-server\/","url_meta":{"origin":1396,"position":5},"title":"Manually attach database in SQL Server","author":"Jitendra","date":"October 6, 2010","format":false,"excerpt":"Download sample database of SQL server and Manually attach database in SQL Server - AdventureWorksDB","rel":"","context":"In "SQL Server"","block_context":{"text":"SQL Server","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/sql\/sqlserver\/"},"img":{"alt_text":"Select Existing mdb file on system to attach","src":"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/10\/Select-Existing-mdb-file-on-system-to-attach-300x258.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/1396","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/comments?post=1396"}],"version-history":[{"count":0,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/1396\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/media?parent=1396"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/categories?post=1396"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/tags?post=1396"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}