One, 32-bit system
Cannot load OCI dll,126
Workaround: Tools, Options->oci Select the Oci.dll in the bin under the Oracle installation directory
Second, the Oracle 11g is installed under 64-bit system, the following error is prompted when using Navicat to connect to Oracle: Cannot load OCI DLL, 126:instant Client package was required for Baic a nd TNS connectionfor More information:http://wiki.navicat.com/wiki/index.php/instant_client_required View the links found above, Navicat only supported 32-bit instant client, although we installed 64-bit Oracle, but because Navicat only supports 32-bit, we also need to download a 32-bit clients to open Navicat, Select tools → options → other →oci, then set the OCI Library as: Oracle Client Installation directory \oci.dll, set SQL *plus to: Oracle Client installation directory \sqlplus.exe
NAVICAT connection to Oracle database hint cannot load OCI DLL resolution