title: Connect Oracle 11g from ASP.NET
body: <p>How can I connect to my <code>Oracle 11g release 11.2.0.1.0</code> ? </p>
  
  <p>My <code>.Net framework is 4</code>. my OS is <code>windows 7 64 bit</code> version.</p>
  
  <p>I read some sample from Google and tested but it's not working.</p>
  
  <p>This is my code. I used <code>VS2012 Express 2012 for Web</code>.</p>
  
  <p>I used Oracle.DataAccess.. Any sample codes or instruction help is appreciated.. </p>
  
  <pre><code>    using System;
      using System.Collections.Generic;
      using System.Linq;
      using System.Web;
      using System.Web.UI;
      using System.Web.UI.WebControls;
      using Oracle.DataAccess.Client;
  
      namespace WebApplication1
      {
          public partial class index : System.Web.UI.Page
          {
              protected void Page_Load(object sender, EventArgs e)
              {
                  OracleConnection connection = new OracleConnection("Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=mySid)));User Id=xxx;Password=xxx;");
                  try
                  {
                      connection.Open();
                  }
                  catch (Exception exp)
                  {
                      Console.WriteLine(exp.Message);
                  }
              }
          }
  
  } 
  </code></pre>
  
  <p>This is my error..</p>
  
  <pre><code>Server Error in '/' Application.
  
  The provider is not compatible with the version of Oracle client
  
  Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
  
  Exception Details: Oracle.DataAccess.Client.OracleException: The provider is not compatible with the version of Oracle client
  
  Source Error: 
  
  
  Line 13:         protected void Page_Load(object sender, EventArgs e)
  Line 14:         {
  Line 15:             OracleConnection connection = new OracleConnection("Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxx)(PORT=xxxx)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=xxx)));User Id=xxx;Password=xxxx;");
  Line 16:             try
  Line 17:             {
  
  Source File: c:\PLanguages\PSources\C#\WebApplication1\WebApplication1\index.aspx.cs    Line: 15 
  
  Stack Trace: 
  
  
  [OracleException (0x80004005): The provider is not compatible with the version of Oracle client]
     Oracle.DataAccess.Client.OracleInit.Initialize() +624
     Oracle.DataAccess.Client.OracleConnection..cctor() +903
  
  [TypeInitializationException: The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception.]
     Oracle.DataAccess.Client.OracleConnection..ctor(String connectionString) +0
     WebApplication1.index.Page_Load(Object sender, EventArgs e) in c:\PLanguages\PSources\C#\WebApplication1\WebApplication1\index.aspx.cs:15
     System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +51
     System.Web.UI.Control.OnLoad(EventArgs e) +92
     System.Web.UI.Control.LoadRecursive() +54
     System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +772
  </code></pre>