=====Installation eines 32 Bit ODBC Treibers unter Windows 7 / 2008 64bit =====

On a 64 Bit Windows you need the 32 Bit Drivers!

Prerequist: tnsnames.ora file with the tnsalias to your database system and a sqlnet.ora configuration file.
See examples:

<code SQL tnsnames.ora>
ORA_MYDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = jupiter)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = GPI)
    )
  )
</code>

<code sql sqlnet.ora>
NAMES.DIRECTORY_PATH= (TNSNAMES)
</code>

Please download the following files from [[http://www.oracle.com/technetwork/topics/winsoft-085727.html| Instant  Client Downloads for Microsoft Windows (32-bit)]]
   
  * instantclient-basic-nt-11.2.0.3.0.zip
  * instantclient-jdbc-nt-11.2.0.3.0.zip
  * instantclient-odbc-nt-11.2.0.3.0.zip


**Hint : If you neeed a connection to a Oracle Database 9 you need the 10.2.0.5 drivers! **

  - Please download the zip
  - Create directory d:\oracle\11_2_client
  - Unzip the content of the zip files in to this folder (NO SUBFOLDER instant client, all files in one directory)
  - Create directory d:\oracle\TNS_NAMES
  - Set the “Runtime Environment”  system variable TNS_ADMIN to the Path of the folder d:\oracle\TNS_NAMES (TNS_ADMIN= d:\oracle\TNS_NAMES)
  - Edit the PATH Variable, add the path d:\oracle\11_2_client to the beginning of the path variable
  - Copy the attached file tnsnames.ora and sqlnet.ora to the directory d:\oracle\TNS_NAMES
  - Open the file tnsnames.ora and check the name/IP Adresse of the DB Server and the service name of the DB, adjust if necessary
  - Open cmd shell and test with “set” if the variable TNS_ADMIN is set to the directory d:\oracle\TNS_NAMES
  - Check the path variable, if in the path “d:\oracle\11_2_client “ is defined
  - Ping the name of the dbserver (or IP Adresse) used in the file tnsnames.ora if the DB server is reachable
  - With the the CMD Schell, go to the directory d:\oracle\11_2_client and start the “odbc_install.exe” program
  - Open Explorer and go the directory “c:\windows\syswow64”
  - Open the ODBC 32 Bit Manager “odbcad32.exe”
  - Create new System DNS with the Oracle Driver “Oracle in instantclient_11_2"
  - From TNS SERVICE NAME check carefully that the  TNS_ALIAS “ORA_MYDB” is visible over the drop down box “connection “ and select this value (if not the TNS_ADMIN parameter or the file tnsname.ora has a problem!)
  - Insert Username and password and check the connection