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
Diese Website verwendet Cookies. Durch die Nutzung der Website stimmen Sie dem Speichern von Cookies auf Ihrem Computer zu. Außerdem bestätigen Sie, dass Sie unsere Datenschutzbestimmungen gelesen und verstanden haben. Wenn Sie nicht einverstanden sind, verlassen Sie die Website.Weitere Information
"Autor: Gunther Pipperr"
dba/32bit_odbc_auf_64_bit_windows.txt · Zuletzt geändert: 2015/10/09 10:20 von gpipperr