How to Install Oracle 11 ODBC driver 11.1.0.6
2 years ago
Originally Published: 2013-03-19
Article Number
000066498
Applies To
Support for  Oracle 10g and 11g requires the Oracle 11 ODBC driver (11.1.0.6). This driver is backwards compatible to Oracle 9.
Issue

Installing the supported Oracle ODBC driver v11.1.0.6

 


Resolution
Ensure that you have removed all previous ODBC configuration from enVision.

Verify no registry entries for ORACLE exist under HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\


Now locate the following files from the official Oracle website download them.

NOTE: Even though the Operating system is running on a 64-bit architecture, the ODBC service used by enVision requires this specific driver.


http://www.oracle.com/technetwork/topics/winsoft-085727.html

instantclient-basic-win32-11.1.0.6.0.zip (43,316,697 bytes)
instantclient-odbc-win32-11.1.0.6.0.zip (725,154 bytes)

 

Extract all contents from both ZIP files to the same location.
After the files are extracted open a command prompt and navigate to the folder location and execute odbc_install.exe.

Verify that the driver was successfully installed by checking the Drivers tab on the ODBC Data Source Administrator. Look for the Oracle in instantclient_11_1.
Select the newly added driver when configuring ODBC Data Sources.