Navicat Connect Oracle Error: Cannot load OCI DLL, 126

64-bit Win7 installed oracle11g using navicat for oraclecannot load OCI dll,126


Workaround:

 Navicat menu-Tools-and Options->oci Select the Oci.dll in the bin under the Oracle installation directory

But the findings are still an error.

Cannot load OCI DLL, 126:instant Client package was required for Baic and TNS Connection , for moreinformation:http://wiki.navicat.com/wiki/index. Php/instant_client_required


Solution:

Download Oracle for 32-bit tools

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


Because Oracle official download thing to log in, very troublesome. Attached Baidu Plate link


The following is the complete workaround:

Step 1: Download the file in the above address:instantclient-basic-nt-12.1.0.2.0.zip,

Step 2: Unzip this installation package to:D:/app/administrator/product/instantclient_2_2_x32

Step 3: Open navicat, select tools → options → other →oci, then set up OCI Library as: d:app/administrator/product/instantclient_12_2_x32/ Oci.dll, set SQL *plus to:D:/app/administrator/product/11.2.0/dbhome_1/BIN/sqlplus.exe. Are you sure.

Step 4: Test success.


Navicat Connect Oracle Error: Cannot load OCI DLL, 126