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

64-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

View the link page tip above, Navicat only support 32-bit instant client, so although we have 64-bit Oracle installed, because NAVICAT only supports 32-bit, So we also need to download an Oracle 32-bit client: http://www.oracle.com/technetwork/topics/winsoft-085727.html.

The following is the complete workaround:

Step 1: Download the file (download the corresponding version according to your navicat version) at the above address:instantclient-basic-nt-12.1.0.2.0.zip,

Step 2: Unzip this installation package to:c:/instantclient_2_2_x32

Step 3: Open navicat, select tools → options → other →oci, then set up OCI Library for:c:/instantclient_2_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.

This article is from the "Jianbo" blog, make sure to keep this source http://jianboli.blog.51cto.com/12075002/1886459

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