1. 安装unixodbc
apt-get install unixodbc
2. 安装mysql odbc驱动
apt-get install libmyodbc
3. 配置mysql odbc驱动
编辑/etc/odbcinst.ini
[MySQL] Description = odbc driver for MySQL #Driver = /usr/lib/odbc/libmyodbc.so #Setup = /usr/lib/odbc/libodbcmyS.so Driver64 = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so Setup64 = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so FileUsage = 1
4. 添加DSN
编辑/etc/odbc.ini
[my_dsn]
Description = emma database on devel2
Trace = On
TraceFile = stderr
Driver = MySQL
Server = 10.3.15.40
PORT = 3306
DATABASE = mydatabase
User = root
Password = mypassword
OPTION = 67108864
5. 测试连接
isql my_dsn