tar -zxf unixODBC-2.3.7.tar.gz
cd unixODBC-2.3.7
./configure --prefix=/usr/local/unixODBC-2.3.7 --includedir=/usr/include --libdir=/usr/local/lib -bindir=/usr/bin --sysconfdir=/usr/local/etc
make && make install
tar -zxf mysql-connector-odbc-5.3.13-linux-glibc2.12-x86-64bit.tar.gz
cd mysql-connector-odbc-5.3.13-linux-glibc2.12-x86-64bit/lib
cp libmyodbc5w.so /usr/local/lib
cd ..
cd bin
注册驱动
1
./myodbc-installer -d -a -n "MySQL ODBC 5.3 Driver" -t "DRIVER=/usr/lib/libmyodbc5w.so;SETUP=/usr/lib/libmyodbc5w.so"
0.0.0.3 配置odbc
编辑文件odbc.ini,把下面的内容加上去
1
vi /etc/odbc.ini
1
2
3
4
5
6
7
8
9
10
[mysqldb]
Driver = /usr/local/lib/libmyodbc5w.so
Description = MyODBC 5 Driver DSN
SERVER = 192.168.1.71
PORT = 3306
USER = root
Password = root
Database = test
OPTION = 3
charset=UTF8
测试
1
isql mysqldb -v
0.0.0.4 配置Oracle
database gateway for odbc简称dg4odbc
oracle 11.2.0.4默认安装了odbc透明网关
验证