about ODBC linux

[Junquan Liu]

Try to connect mysql by oracle,so I installed unixODBC and mysql connector/ODBC successfully .
[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

after mysql connector/ODBC was installed,the message hinted "odbc.ini,odbcinst.ini" in directory"/etc/unixODBC"(not diffrent above"/usr/local/etc")

so, 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 =

DB mysql is following:

mysql> use mysql;
Database changed
mysql> select host,user,password from user;
+-----------+--------------+-------------------------------------------+
| host | user | password |
+-----------+--------------+-------------------------------------------+
| localhost | asteriskuser | *74B1C21ACE0C2D6B0678A5E503D2A60E8F9651A3 |
| % | root | *74B1C21ACE0C2D6B0678A5E503D2A60E8F9651A3 |
+-----------+--------------+-------------------------------------------+


isql errors：
[oracle@test ~]$ isql -v myodbc3 root test
[S1000][unixODBC][MySQL][ODBC 3.51 Driver]Unknown database 'dbtest'
[ISQL]ERROR: Could not SQLConnect


any solutions,thanks!