Enterprise Integration Zone is brought to you in partnership with:

Behind DotNetBlocks.com is a software engineer with over 10 years of experience in Microsoft technologies and is currently obtaining a Masters in IT. His primary focus is typically on software architecture, web applications, and interactions amongst various systems. Todd is a DZone MVB and is not an employee of DZone and has posted 47 posts at DZone. You can read more from them at their website. View Full User Profile

What is ODBC?

05.15.2013
| 1661 views |
  • submit to reddit
According to Microsoft, ODBC is a specification for a database API. This API is database and operating system agnostic due to the fact that the primary goal of the ODBC API is to be language-independent. Additionally, the open functions of the API are created by the manufactures of DBMS-specific drivers. Developers can use these exposed functions from within their own custom applications so that they can communicate with DBMS through the language-independent drivers.

ODBC Advantages

  • Multiple ODBC drivers for each DBSM

    • Example

      • Oracle’s ODBC Driver

      • Merant’s Oracle Driver
      • Microsoft’s Oracle Driver
  • ODBC Drivers are constantly updated for the latest data types
  • ODBC allows for more control when querying
  • ODBC allows for Isolation Levels

ODBC Disadvantages

  • ODBC Requires DSN
  • ODBC is the proxy between an application and a database
  • ODBC is dependent on third party drivers

ODBC Transaction Isolation Levels are related to and limited by the transaction management capabilities of the data source.

Transaction isolation levels:

  • READ UNCOMMITTED

    • Data is allowed to be read prior to the committing of a transaction.

  • READ COMMITTED

    • Data is only accessible after a transaction has completed

  • REPEATABLE READ

    • The same data value is read during the entire transaction

  • SERIALIZABLE

    • Transactions have no effect on other transactions

Published at DZone with permission of Todd Merritt, author and DZone MVB. (source)

(Note: Opinions expressed in this article and its replies are the opinions of their respective authors and not those of DZone, Inc.)