Error in 32-bit system: cannot load OCI DLL, 126

Solution: Navicat menu – tools – > Options – > OCI select oci.dll in bin under Oracle installation directory

Error in Windows Server 2008: cannot load OCI DLL, 126

Oracle 11g R2 is installed on Windows Server 2008 server. When using Navicat to connect Oracle, the following error will be prompted:

Cannot load OCI DLL, 126: Instant Client package is required for Baic and TNS connection ，
For more information: http://wiki.navicat.com/wiki/index.php/Instant_client_required

According to the above link page, Navicat only supports 32-bit instant client. Therefore, although we have installed 64 bit Oracle, we need to download a 32-bit client as Navicat only supports 32-bit http://www.oracle.com/technetwork/topics/winsoft-085727.html 。

Here is the complete solution:

Step 1: download the file from the above address: instantclient-basic-nt-12.1.0.2.0.zip,

Step 2: unzip the installation package to: D]/APP/administrator/product/instantclient_ 2_ 2_ x32

Step 3: open Navicat, select tools → options → other → OCI, and then set OCI library as D: APP/administrator/product/instantclient_ 12_ 2_ X32/oci.dll, set SQL * plus as: D]/APP/administrator/product/11.2.0/dbhome_ 1/BIN/sqlplus.exe.Sure

Step 4: the test is successful