linux ODBC连接mysql

[Junquan Liu]

想通过oracle连接mysql，根据网上的指引，先安装unixODBC，然后安装mysql connector/ODBC。
[root@test unixODBC-2.3.1]# odbcinst -j
unixODBC 2.3.1
DRIVERS............: /usr/local/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

但装完mysql connector/ODBC，又提示我odbc.ini,odbcinst.ini在/etc/unixODBC下(上面显示odbc.ini路径为/usr/local/etc)
于是，我把环境变量export ODBCINI=/etc/unixODBC/odbc.ini
[oracle@test ~]$ more $ODBCINI
[ODBC Data Sources]
myodbc3 = MyODBC 3.51 Driver DSN

[myodbc3]
Driver = /usr/lib64/libmyodbc3.so
Description = MyODBC 3.51 Driver DSN
SERVER = 192.168.0.1
PORT = 3306
USER = root
PASSWORD = test
DATABASE = dbtest
OPTION = 3
SOCKET =

[Default]
Driver = /usr/lib64/libmyodbc3.so
Description = MyODBC 3.51 Driver DSN
SERVER = 192.168.0.1
PORT = 3306
USER = root
PASSWORD = test
DATABASE = dbtest
OPTION = 3
SOCKET =

另外，mysql的情况如下：
mysql> use mysql;
Database changed
mysql> select host,user,password from user;
+-----------+--------------+-------------------------------------------+
| host | user | password |
+-----------+--------------+-------------------------------------------+
| localhost | asteriskuser | *74B1C21ACE0C2D6B0678A5E503D2A60E8F9651A3 |
| % | root | *74B1C21ACE0C2D6B0678A5E503D2A60E8F9651A3 |
+-----------+--------------+-------------------------------------------+


而在客户端用isql时报错如下：
[oracle@test ~]$ isql -v myodbc3 root test
[S1000][unixODBC][MySQL][ODBC 3.51 Driver]Unknown database 'dbtest'
[ISQL]ERROR: Could not SQLConnect


对mysql、unixODBC、myodbc不熟，请各位指导，谢谢！