- 论坛徽章:
- 1
|
linux4.8(x64), ORACLE9208
ORACLE9208 安装在LINUX4.8(x64) 的服务器上,现打算搭建透明网关,指向MYSQL,
所需要软件包:mysql, unixODBC 均已经安装,如下:
[root@erp-standby tmp]# rpm -ivh unixODBC-2.2.11-1.RHEL4.1.x86_64.rpm
warning: unixODBC-2.2.11-1.RHEL4.1.x86_64.rpm: V3 DSA signature: NOKEY, key ID db42a60e
Preparing... ########################################### [100%]
package unixODBC-2.2.11-1.RHEL4.1 is already installed
[root@erp-standby tmp]# rpm -ivh unixODBC-2.2.11-1.RHEL4.1.i386.rpm
warning: unixODBC-2.2.11-1.RHEL4.1.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e
Preparing... ########################################### [100%]
package unixODBC-2.2.11-1.RHEL4.1 is already installed
[root@erp-standby tmp]# rpm -q ODBC
package ODBC is not installed
[root@erp-standby tmp]# rpm -ivh mysql-4.1.22-2.el4.x86_64.rpm
warning: mysql-4.1.22-2.el4.x86_64.rpm: V3 DSA signature: NOKEY, key ID db42a60e
Preparing... ########################################### [100%]
package mysql-4.1.22-2.el4 is already installed
[root@erp-standby tmp]# rpm -ivh mysql-4.1.22-2.el4.i386.rpm
warning: mysql-4.1.22-2.el4.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e
Preparing... ########################################### [100%]
package mysql-4.1.22-2.el4 is already installed
[root@erp-standby tmp]# rpm -q mysql
mysql-4.1.22-2.el4
mysql-4.1.22-2.el4
[root@erp-standby tmp]# rpm -q ODBC
package ODBC is not installed
[root@erp-standby tmp]#
我从网上找了一些案例,关于ORACLE到MYSQL,其中配置ODBCINST.INI, ODBC.INI时,使用的驱动:libmyodbc5.so,libodbcmyS.so
如下:
[mysql]
Description = mysql
Driver = /usr/lib/libmyodbc5.so
Driver64 = /usr/lib64/libmyodbc5.so
Setup = /usr/lib/libodbcmyS.so
Setup64 = /usr/lib64/libodbcmyS.so
UsageCoun = 1
CPTimeout =
CPReuse =
但其环境都是LINUX5,而我的是LINUX4,找不到libmyodbc5.so 这个文件,类似的也找不到,
[oracle5@erp-standby lib]$ ls -rtl *odbc*
-rwxr-xr-x 1 root root 4168 Nov 22 2005 liboraodbcS.so.1.0.0
-rwxr-xr-x 1 root root 6004 Nov 22 2005 liboplodbcS.so.1.0.0
-rwxr-xr-x 1 root root 4504 Nov 22 2005 libodbctxtS.so.1.0.0
-rwxr-xr-x 1 root root 159244 Nov 22 2005 libodbctxt.so.1.0.0
-rwxr-xr-x 1 root root 395440 Nov 22 2005 libodbc.so.1.0.0
-rwxr-xr-x 1 root root 5600 Nov 22 2005 libodbcpsqlS.so.1.0.0
-rwxr-xr-x 1 root root 229772 Nov 22 2005 libodbcpsql.so.2.0.0
-rwxr-xr-x 1 root root 210168 Nov 22 2005 libodbcpsql.so.1.0.0
-rwxr-xr-x 1 root root 3192 Nov 22 2005 libodbcnnS.so.1.0.0
-rwxr-xr-x 1 root root 5732 Nov 22 2005 libodbcmyS.so.1.0.0
-rwxr-xr-x 1 root root 3564 Nov 22 2005 libodbcminiS.so.1.0.0
-rwxr-xr-x 1 root root 65300 Nov 22 2005 libodbcinst.so.1.0.0
-rwxr-xr-x 1 root root 422492 Nov 22 2005 libodbcinstQ.so.1.0.0
-rwxr-xr-x 1 root root 3148 Nov 22 2005 libodbcdrvcfg2S.so.1.0.0
-rwxr-xr-x 1 root root 3440 Nov 22 2005 libodbcdrvcfg1S.so.1.0.0
-rwxr-xr-x 1 root root 29592 Nov 22 2005 libodbccr.so.1.0.0
lrwxrwxrwx 1 root root 20 Mar 31 18:03 liboraodbcS.so.1 -> liboraodbcS.so.1.0.0
lrwxrwxrwx 1 root root 20 Mar 31 18:03 liboplodbcS.so.1 -> liboplodbcS.so.1.0.0
lrwxrwxrwx 1 root root 20 Mar 31 18:03 libodbctxtS.so.1 -> libodbctxtS.so.1.0.0
lrwxrwxrwx 1 root root 19 Mar 31 18:03 libodbctxt.so.1 -> libodbctxt.so.1.0.0
lrwxrwxrwx 1 root root 16 Mar 31 18:03 libodbc.so.1 -> libodbc.so.1.0.0
lrwxrwxrwx 1 root root 16 Mar 31 18:03 libodbc.so -> libodbc.so.1.0.0
lrwxrwxrwx 1 root root 21 Mar 31 18:03 libodbcpsqlS.so.1 -> libodbcpsqlS.so.1.0.0
lrwxrwxrwx 1 root root 21 Mar 31 18:03 libodbcpsqlS.so -> libodbcpsqlS.so.1.0.0
lrwxrwxrwx 1 root root 20 Mar 31 18:03 libodbcpsql.so.2 -> libodbcpsql.so.2.0.0
lrwxrwxrwx 1 root root 20 Mar 31 18:03 libodbcpsql.so.1 -> libodbcpsql.so.1.0.0
lrwxrwxrwx 1 root root 20 Mar 31 18:03 libodbcpsql.so -> libodbcpsql.so.2.0.0
lrwxrwxrwx 1 root root 19 Mar 31 18:03 libodbcnnS.so.1 -> libodbcnnS.so.1.0.0
lrwxrwxrwx 1 root root 19 Mar 31 18:03 libodbcmyS.so.1 -> libodbcmyS.so.1.0.0
lrwxrwxrwx 1 root root 19 Mar 31 18:03 libodbcmyS.so -> libodbcmyS.so.1.0.0
lrwxrwxrwx 1 root root 21 Mar 31 18:03 libodbcminiS.so.1 -> libodbcminiS.so.1.0.0
lrwxrwxrwx 1 root root 20 Mar 31 18:03 libodbcinst.so.1 -> libodbcinst.so.1.0.0
lrwxrwxrwx 1 root root 24 Mar 31 18:03 libodbcdrvcfg2S.so.1 -> libodbcdrvcfg2S.so.1.0.0
lrwxrwxrwx 1 root root 24 Mar 31 18:03 libodbcdrvcfg1S.so.1 -> libodbcdrvcfg1S.so.1.0.0
lrwxrwxrwx 1 root root 18 Mar 31 18:03 libodbccr.so.1 -> libodbccr.so.1.0.0
lrwxrwxrwx 1 root root 21 Mar 31 18:42 libodbcinstQ.so.1 -> libodbcinstQ.so.1.0.0
lrwxrwxrwx 1 root root 21 Mar 31 18:42 libodbcinstQ.so -> libodbcinstQ.so.1.0.0
[oracle5@erp-standby lib]$ pwd
/usr/lib
这样,我用了个最相似的驱动 /usr/lib/libodbc.so,如下:
[root@erp-standby ~]# more /etc/odbcinst.ini
# Example driver definitinions
#
#
trace=yes
# Included in the unixODBC package
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/libodbcpsql.so
Setup = /usr/lib/libodbcpsqlS.so
FileUsage = 1
# Driver from the MyODBC package
# Setup from the unixODBC package
#[MySQL]
#Description = ODBC for MySQL
#Driver = /usr/lib/libmyodbc.so
#Setup = /usr/lib/libodbcmyS.so
#FileUsage = 1
[mysql]
# add by zhang-hf 2015-05-14 18:14
Description = mysql
Driver = /usr/lib/libodbc.so
Driver64 = /usr/lib64/libodbc.so
Setup = /usr/lib/libodbcmyS.so
Setup64 = /usr/lib64/libodbcmyS.so
UsageCoun = 1
CPTimeout =
CPReuse =
[root@erp-standby ~]#
但测试时报错:
[root@erp-standby ~]# isql -v mysql_144
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect
[root@erp-standby ~]#
请教,该如何配置?
2 我明明安装了包 unixODBC-2.2.11-1.RHEL4.1.i386.rpm,为何 rpm -q ODBC 时,却查不到?
|
|