Navicat Connect Oracle Error: Cannot load OCI DLL, 126

32-bit system error: Cannot load OCI dll,126

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

Error in Windows Server 2008: Cannot load OCI dll,126

The Oracle 11g R2 is installed on the Windows Server 2008 server and the following error is prompted when using Navicat to connect to Oracle:

Cannot load OCI DLL, 126:instant Client package was required for Baic and TNS connection, for more Information:http://wik I.navicat.com/wiki/index.php/instant_client_required

View the above link page tip, Navicat only support 32-bit instant client,
So, although we have 64-bit Oracle installed, because NAVICAT only supports 32-bit, we also need to download a 32-bit client,
：

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

The following is the complete workaround:

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

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

Step 3: Open navicat, select tools → options → other →oci, then set up OCI Library as: d:app/administrator/product/instantclient_11_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