title: How to run applications which use Oracle 10g client on window 7 64 bit?
body: <p>I am getting error &quot;[Oracle][ODBC][Ora] ORA- 12154: TNS: could not resolve the connect identifier specified.&quot; when I am trying to connect to remote database using 3rd party software. I am using Windows 7 64 OS and Oracle 10g 32 bit client.
  I have tried all the solution given on stackoverflow, but unable to solve the issue on the following links.</p>
  <p><a href="https://stackoverflow.com/questions/162762/ora-12154-error">Ora 12154 error</a></p>
  <p><a href="https://stackoverflow.com/questions/13309702/odp-net-ora-12154-tns-error-only-when-run-as-service">ODP.NET ORA-12154 TNS error only when run as service</a></p>
  <p><a href="https://stackoverflow.com/questions/3477445/oracle-0x80004005ora-12154-tnscould-not-resolve-the-connect-identifier">Oracle (0x80004005)ORA-12154: TNS:could not resolve the connect identifier</a></p>
  <p><a href="https://stackoverflow.com/questions/7957955/ora-12154-could-not-resolve-the-connect-identifier-specified">ORA-12154 could not resolve the connect identifier specified</a></p>
  <p><strong>Update</strong></p>
  <p>As per the link below from Oracle one needs to install Oracle 10.2.0.5 patch to run on Windows 7. Please let me know where to find this patch as it is not available to download free from Oracle's website.</p>
  <p><a href="http://docs.oracle.com/cd/B19306_01/relnotes.102/b14264/toc.htm" rel="nofollow noreferrer">http://docs.oracle.com/cd/B19306_01/relnotes.102/b14264/toc.htm</a></p>
  <p><strong>Update 2:</strong></p>
  <p>I found another <a href="https://community.oracle.com/thread/182468?start=0&amp;tstart=0" rel="nofollow noreferrer">link</a> which says that I need to have the same version of ODBC manager as that of the Oracle Client. Hence now this sums up to that I need the version 10.0.2.5 of both Oracle client and of ODBC manager. But what I found is that there are 2 different versions of ODBC manager in my computer. One is at <code>C:\Windows\System32</code> and other at <code>C:\Windows\SysWOW64</code>. After some googling I came to know that WOW (Windows on Windows) is used for running 32 bit applications in 64 bit Windows OS. When I test the connection to database through ODBC manager in System32 folder, it gets connected but when I try to connect to the same database through an application I get the following error:
  <code>[Microsoft][ODBC Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_ENV failed.</code>
  Could it be possible that the applications on my system try to connect to the Database through the ODBC manager which is not working properly (inside <code>SysWOW64</code> folder)?
  Please let me know how to solve this and if there is some information that I may be missing to provide.</p>