Navicat for Oracle tips cannot load OCI dll,193 workaround

The intranet has a Windows Server 2012 with Navicat 11.1.8 installed

When you connect to Oracle, you are prompted

Cannot load OCI dll,193:d:\program Files (x86) \premiumsoft\navicat premium***

Install CLIETN package is required fro basic and TNS connection

For more infomation:http://*********

Here's how to fix it:

To download the components, the link addresses are as follows:

Http://www.oracle.com/technetwork/cn/topics/winsoft-095945-zhs.html

To download the corresponding Oracle version, the Oracle version I need to connect to is 10

So the downloaded package is

Instantclient-basic-win32-10.2.0.4.zip

Instantclient-sqlplus-win32-10.2.0.4.zip

First unpack the first package and put it on the D drive, then the path is D:\instantclient_10_2

Open the 2nd package and copy all the files inside the D:\instantclient_10_2.

Open navicat-> Tools, options, other->oci

Choose

OCI Libray (oci.dll) *: D:\instantclient_10_2\oci.dll

Sql*plus:d:\instantclient_10_2\sqlplus.exe

Click OK, close Navicat, open again, you can connect.

This article is from the "Falling Star" blog, make sure to keep this source http://xiao987334176.blog.51cto.com/2202382/1640991

Navicat for Oracle tips cannot load OCI dll,193 workaround