title: Oracle.DataAccess.Client.OracleException at Connection.Open()
body: <p>this question can look like a clone of others, but I can't find a correct answer to this one.
  This is my scenario:
  I have a C# software called by webservices that need to write to an oracle database.
  In my test server no problems, it works like a charm, but, in another equal server it gives to me this error: </p>
  
  <blockquote>
    <p>Oracle.DataAccess.Client.OracleException     at
    Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32
    errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx*
    pOpoSqlValCtx, Object src, String procedure, Boolean bCheck, Int32
    isRecoverable)    at
    Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode,
    OracleConnection conn, IntPtr opsErrCtx, Object src)    at
    Oracle.DataAccess.Client.OracleConnection.Open()</p>
  </blockquote>
  
  <p>With no other messages.
  I thought that it is an error installing oracle client, but, another small application that I wrote to test oracle connection works:</p>
  
  <pre><code>var connectionString = ConfigurationManager.AppSettings["connectionString"];
  using (OracleConnection nwindConn = new OracleConnection(connectionString))
  {
     nwindConn.Open();
     Console.WriteLine("opened");
  }
  </code></pre>
  
  <p>ConnectionString:</p>
  
  <pre><code>Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=thisdatabase.thisinstance)(PORT=1521))(LOAD_BALANCE=yes)(FAILOVER=on)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=serv)(FAILOVER_MODE=(TYPE=SESSION)(METHOD=BASIC)(RETRIES=180)(DELAY=5))));User ID=myuser;Password=mypsw;
  </code></pre>
  
  <p>So, the problem, I think is in the application configuration, <em>but why the same works on other server?</em>
  I tried to edit Project and Solution debug platform Configuration but the problem still exists.. Any suggestions?</p>