title: Ora 12454 tns could not resolve the connect identifier specified
body: <p>I have wcf that runs on  windows 2008 R2 (oracle Client 32/64), and when i trying to update table, i am getting this error <code>ora 12454 tns could not resolve the connect identifier specified</code>,if i run this on local pc all work's fine Update function is fine,but when i run this on server i getting error.</p>
  
  <p>After a looking for answer i think it can be error in my connection string,but all sems ok to me.</p>
  
  <pre><code>  &lt;connectionStrings&gt;
      &lt;add name="SnOracle" connectionString="Data Source=ORCL;User Id=Vn;Password=Vn;"/&gt;
    &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>Here image of error </p>
  
  <p><img src="https://i.stack.imgur.com/ILOLl.png" alt="enter image description here"></p>
  
  <p>Here the part of update code</p>
  
  <pre><code>             using (OracleConnection con = new OracleConnection(connStr))
                              {
                                  try
                                  {
                                      con.Open();
                                      OracleCommand cmd = new OracleCommand();
                                      cmd.Connection = con;
                                  for (int i = 0; i &lt; Rows.Count; i++)
                                      {
          cmd.CommandText = "INSERT INTO SNXRATES" +  "(KOD_BANK, 
  
      TAARICH_ERECH,KODCURRBANK,RATE_TYPE,RATE_VALUE,FACTOR_1,SERIAL_IN,SERIAL_OUT1,
      SERIAL_OUT2,CURRBASE,SERIAL_OUT3 )" +
  
          "VALUES" +  "('" + Rows[i].KOD_BANK + 
      "','" + Rows[i].TAARICH_ERECH + "','" + 
      Rows[i].KODCURRBANK + "',"  + Rows[i].RATE_TYPE + 
      "," + Rows[i].RATE_VALUE + "," + Rows[i].FACTOR_1 + "," + Rows[i].SERIAL_IN + "," +
  
   Rows[i].SERIAL_OUT1 + "," + Rows[i].SERIAL_OUT2 + ",'" + Rows[i].CURRBASE + "'," + Rows[i].SERIAL_OUT3 + ")";
  
                                          cmd.ExecuteNonQuery();
                                      }
  
                                  }
                                  catch (Exception ex)
                                  {
                                      //here i use  MessageBox to see error
                                      MessageBox.Show(ex.Message+"  || "+ex.Source);
                                      succeeded = false;
                                  }
  
                              }
  
                          }
                          return succeeded;
  
                      }
  </code></pre>