title: Where is TNSNAMES.ORA?
body: <p>I am working on a Windows server and access Oracle databases using the Oracle ODBC driver. I have Oracle ODBC connections that work fine on this machine.</p>
  
  <p>However I want to add a new connection, and when testing it I get the error </p>
  
  <pre><code>Unable to connect
  SQL State=S1000
  [Oracle][ODBC][Ora] ORA-12170: TNS: Connect timeout occurred
  </code></pre>
  
  <p>I presume, though I am no DBA, that this has something to do with my TNS Service Name not being in TNSNAMES.ORA which points oracle toward the right server, port, etc.</p>
  
  <p>However I cannot find TNSNAMES.ORA</p>
  
  <p>I have an ORACLE_HOME environment variable, but it is empty.</p>
  
  <p>Where can I find this file or otherwise configure my TNS names?</p>