title: How to set proper path to TNSNAMES file in C# application?
body: <p>I have a program in C# that use ODP.NET dlls:</p>
  
  <pre><code>oci.dll, ociw32.dll, Oracle.DataAccess.dll,
  orannzsbb11.dll, oraocci11.dll, oraociicus11.dll,
  OraOps11w.dll. 
  </code></pre>
  
  <p>I've got 2 computers. First with whole ODAC package installed, and second without that package. But I have all required dlls in my exe directory, so ODAC is not a problem I think. </p>
  
  <p>The difference between these computers is the path to the <code>TNSNAMES</code> file. </p>
  
  <pre><code>First: C:\app\OraHome_1\Network\admin\
  Second: C:\Oracle\product\11.2.0\client_1\network\admin
  </code></pre>
  
  <p>On the first computer, the program works fine. But on the second one with the same connection string, I get the error:</p>
  
  <pre><code>cannot open connection (ORA-12154)
  </code></pre>
  
  <p>Using SQL Plus I can connect on both computers. How can I show my program the proper path to the <code>tnsnames.ora</code> file? </p>