日期:2014-05-16  浏览次数:20413 次

Navicat连接Oracle10g

用Navicat连接Mysql用得挺好的,渐渐喜欢上这个导航小猫了。

于是想拿它连接ORACLE,可是会报错:

"unsupported server character set ZHS16GBK"

查了半天才知道是没有设置好"oci.dll",于是:

Navicat:"工具->选项...->其它->OCI-在Oracle的数据库文件中找到oci.dll"文件选中即可。

在Oracle/bin下找到了它.

?

OCI=Oracle Call Interface;

oci.dll自然就是 Oracle Call Interface for Windows了;

?

这么一想,Navicat 要访问Oracle,自然是少不了oci.dll了。

http://download.oracle.com/docs/cd/B10501_01/win.920/a95497/whatsnew.htm

?

下面这段来自Oracle网站:

What is the Oracle Call Interface?

The Oracle Call Interface (OCI) is an application programming interface (API) that allows applications written in C to interact with one or more Oracle Servers. OCI gives your programs the capability to perform the full range of database operations that are possible with Oracle8i database, including SQL statement processing and object manipulation.

?

看来是给Navicat这样的东西用的。

?