Install Oracle ODBC Driver for Crystal Report

Install Oracle ODBC Driver in Windows 7(64-bit)

Try to install OracleXE 32-bit and 64-bit version to install the odbc driver for starting Crystal Report but fail.

And fail to install ODAC to fix 32bit odbc driver for Crystal Report

Fix

  • Download instantclient-odbc-nt-11.2.0.2.0 and instantclient-basic-nt-11.2.0.2.0, extract them to the same folder, run
    odbc_install.exe
  • Add the TNS_ADMIN environment variable indicating the path of tnsnames.ora file such as c:\oracle\11.2.0\CLIENT\network\admin
  • Run c:\windows\SysWOW64\odbcad32.exe to configure DSN by choosing a driver which like instant_client_11, rather than calling %windir%\system32\odbcad32.exe to install the driver.

Reference

https://itkbs.wordpress.com/2014/07/28/how-to-install-odbc-driver-for-oracle-in-windows-7/