2 Replies Latest reply: Nov 1, 2012 10:15 PM by 936666 RSS

    ODBC and OLEDB and Oralce Client

    936666
      What is the difference in using the below commands in .net

      using System.Data.Odbc;----> It will be referring to Open database Connectivity (common across all database )
      using System.Data.Oledb;----->It will be referring to Object Linking and Embedding, Database
      using Oracle.DataAccess.Client;----->It is provided my Microsoft for Oracle
      using Oracle.DataAccess.Types;-------> .NET DataProvider from Oracle ------------------>is this a ODP connection?

      what is the significant difference in these commands ODBC ,OLEDB and ODP


      Thanks!
        • 1. Re: ODBC and OLEDB and Oralce Client
          Johnsung-Oracle
          Hello

          in short they are all different data access methods. Different standards for different purposes.
          To explain the differences would be better if I point you to the Microsoft documentation
          as this is where they are specified:

          http://msdn.microsoft.com/en-us/library/aa968814%28v=vs.85%29.aspx
          Follow links for ODBC Overview here :: http://msdn.microsoft.com/en-us/library/ms710220%28v=vs.85%29.aspx
          OLEDB Overview here ::: http://msdn.microsoft.com/en-us/library/ms718124%28v=vs.85%29.aspx

          For System.Data.Odbc
          see
          http://msdn.microsoft.com/en-us/library/system.data.odbc.aspx
          It lets you use .net framework with ODBC drivers (not just oracle's ODBC driver of course).

          System.Data.Oledb
          http://msdn.microsoft.com/en-us/library/system.data.oledb%28v=vs.100%29.aspx
          For using .net framework with an OLEDB provider


          The last two are Oracle Data Provider for .net - ODP.net (written by Oracle not Microsoft)
          From the ODP.net docs:
          "
          The Oracle.DataAccess.Client namespace contains ODP.NET classes and enumerations.
          The Oracle.DataAccess.Types namespace contains the Oracle Data Provider for .NET Types (ODP.NET Types).
          "

          Hope that gives you pointers to research each of those!

          John