因为偶然的原因,想通过oracle访问mysql,要使oracle访问mysql,必须配置“网关”
作为以后的参考,故总结了一下从oracle访问mysql的步骤:
1.先简单介绍下环境
操作系统:windows xp
oracle:9.2.1
mysql:5.0
2.下载mysql的odbc驱动,我用的是myodbc 3.5并安装
3.配置odbc数据源,在控制面板中配置就可以了,使用系统DSN,取名为mysqltest
4.在D:\oracle\ora92\hs\admin下建立initmysqltest.ora文件
输入:
HS_FDS_CONNECT_INFO = mysqltest
HS_FDS_TRACE_LEVEL = 0
5.在D:\oracle\ora92\network\admin下修改
listener.ora
输入:
(SID_DESC =
(SID_NAME = mysqltest)
(ORACLE_HOME = D:\oracle\ora92)
(PROGRAM = hsodbc)
)
6.修改tnsnames.ora
输入:
mysqltest =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = chengjin)(PORT = 1521))
(CONNECT_DATA &#