Centos7.0安装64位Mysql,使用32位OPDBC访问总是提示找不到驱动
马壮mz 2016-11-21 04:45:06 操作系统:Centos7.0
MySql:64位
ODBC驱动:32位
因为我的应用是32位的,所以我必须要使用32位的驱动进行访驱动配置文件如下:
[root@localhost etc]# vi odbc.ini
[test-mysql]
Description = MySQL connection to 'mysql' database
Driver = MySQL ODBC 5.3 Unicode Driver
Database = mysql
Server = localhost
UserName = root
Password = 123456
Port = 3306
Socket = /var/lib/mysql/mysql.sock
//odbcinst.ini
[root@localhost etc]# cat odbcinst.ini
[PostgreSQL]
Description=ODBC for PostgreSQL
Driver=/usr/lib/psqlodbcw.so
Setup=/usr/lib/libodbcpsqlS.so
Driver64=/usr/lib64/psqlodbcw.so
Setup64=/usr/lib64/libodbcpsqlS.so
FileUsage=1
[MySQL]
Description=ODBC for MySQL
Driver=/usr/lib/libmyodbc5.so
Setup=/usr/lib/libodbcmyS.so
Driver64=/usr/lib64/libmyodbc5.so
Setup64=/usr/lib64/libodbcmyS.so
FileUsage=1
[MySQL ODBC 5.3 Unicode Driver]
Driver=/usr/lib/libmyodbc5w.so
Setup=/usr/lib/libmyodbcmys.so
UsageCount=2
[MySQL ODBC 5.3 ANSI Driver]
Driver=/usr/lib/libmyodbc5a.so
UsageCount=2
//测试报错
[root@localhost etc]# echo "select 1" | isql -v test-mysql
[01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/libmyodbc5w.so' : file not found
[ISQL]ERROR: Could not SQLConnect
但是在这个路径下是能找得到的这个,如果把上头路径中换成/usr/lib64//libmyodbc5w.so,这样测试连接可以成功。
有没碰到相同经历的给个指导??