title: Connect to an Oracle DB using ODBC
body: <p>I am developing an application that needs to interract with a "lightly documented" Legacy Oracle Database. To Start that process I want to start creating a view into that Database using ODBC links into an MS Access database so I can figure out the DB structure but I can't figure out how to setup the ODBC connection to the Oracle DB.  </p>
  
  <p>I have been able to connect using the Host and Service Name to and view the DB using SQL Developer; but, I can't figure out how to setup ODBC. I am running Windows 7 and have installed Oracle 11g, Oracle Express Edition, the Instant Client and ODBC extensitons; but on the ODBC setup Oracle wants me to pick a TNS Service Name but there is none to pick and there is no place to specify the host.  I tried to setup a TNS in tnsnames.ora; but I am not really sure I know the right location for that file.</p>
  
  <p>I really thought this would be the easy part; but, it really hasn't been.</p>