Oracle gateway for odbc配置
1. 安装gateway
建议新建用户gateway用于安装
useradd -g dba gateway
在.bash_profile中设置ORACLE_HOME,PATH
export ORACLE_HOME=/u02/app/gateway
export PATH=$ORACLE_HOME/bin:$PATH
运行runInstaller,一直下一步即可
2.安装unixODBC和mysql-connector-odbc
检查是否已安装这两个rpm,建议使用最新的版本
3.配置odbc
编辑/etc/odbc.ini
[ODBC Data Sources]
demo = MySQL ODBC Driver 5.5
[demo]
Driver = /usr/lib/libmyodbc5.so
DATABASE = test
DESCRIPTION = MySQL ODBC 5.5.17 Connector Sample
PORT = 3306
SERVER = 127.0.0.1
# UID = demo
# PWD = demo
CHARSET = utf8
TRACEFILE = /tmp/myodbc-demodsn.trc
TRACE = OFF
测试odbc的连接
[root@ydqp143 etc]# isql demo +-----------