This discussion is archived
2 Replies Latest reply: Nov 1, 2012 8:15 PM by 936666 RSS

ODBC and OLEDB and Oralce Client

936666 Newbie
Currently Being Moderated
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

  • 1. Re: ODBC and OLEDB and Oralce Client
    Johnsung Pro
    Currently Being Moderated

    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:
    Follow links for ODBC Overview here ::
    OLEDB Overview here :::

    For System.Data.Odbc
    It lets you use .net framework with ODBC drivers (not just oracle's ODBC driver of course).

    For using .net framework with an OLEDB provider

    The last two are Oracle Data Provider for .net - (written by Oracle not Microsoft)
    From the 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!

  • 2. Re: ODBC and OLEDB and Oralce Client
    936666 Newbie
    Currently Being Moderated


  • Correct Answers - 10 points
  • Helpful Answers - 5 points