Tuesday, July 14, 2009

Installing Oracle 10gR2 x32 ODBC on Windows x64

1. (Optional?) Uninstall all other Oracle software on your system.
2. Download:
a. “Instant Client Package – Basic”
b. “Instant Client Package – ODBC”
c. You MUST use 10.2.0.4 or greater (10.2.0.3 does not seem to install correctly)
d. http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html
3. Unzip both files to the same directory.
a. i.e. C:\Program Files (x86)\instantclient_10_2
4. Set the following SYSTEM (not user) environment variables:
a. LD_LIBRARY_PATH=C:\Program Files (x86)\instantclient_10_2
b. TNS_ADMIN=C:\Program Files (x86)\instantclient_10_2
c. SQLPATH=C:\Program Files (x86)\instantclient_10_2
d. ORACLE_HOME=C:\Program Files (x86)\instantclient_10_2
e. Append to your SYSTEM PATH;C:\Program Files (x86)\instantclient_10_2
5. Run odbc_install.exe located in C:\Program Files (x86)\instantclient_10_2
a. The installer will give no indication of success or failure.
6. Run the x32 ODBC Control Panel
a. Execute: %SystemRoot%\syswow64\odbcad32.exe
i. Please Note:
1. x64 ODBC Control: %SystemRoot%\system32\odbcad32.exe
2. x32 ODBC Control: %SystemRoot%\syswow64\odbcad32.exe
b. System DSN
c. Add…
d. Oracle in instantclient 10_2
i. Data Source Name: Short DSN Name (usually instance ID)
ii. Description: Friendly Description
iii. TNS Service Name: //server:port/instance (where 00000dbs is database server name)
iv. User ID: login id
7. Test (You should see a "Connection Successful" dialog) and Enjoy.

I got a little help from here