1)先安装 :
=======F:\tools\mysql-connector-odbc-5[1].1.5-win32.msi
My13SQL
192.168.0.13
sms
sms.com.cn
database:ad
F:\oracle\product\10.2.0\db_1\hs\admin 新建文件:
initMy13SQL.ora 内容:
HS_FDS_CONNECT_INFO =My13SQL
HS_FDS_TRACE_LEVEL =OFF
F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN 文件修改:
listener.ora:SID_LIST_LISTENER =
(SID_LIST =
(
SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(
SID_DESC =
(SID_NAME = My13SQL)
(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)
(PROGRAM = hsodbc)
)
)
F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN的tnsnames.ora文件修改:
My13SQL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 20100517-1415)(PORT = 1521))
(CONNECT_DATA =
(SID=My13SQL)
)
(HS =ok)
)
4) 创建DBLINK连接
-- Create database linkcreate public database link My13SQL
connect to "ad" identified by "sms.com.cn"
using 'My13SQL';
5) 查询
select * from sg.emp@My13SQL; 连接的是 服务器端的 trans.ora 的服务名
6) 通过以上配置,发现有些数据不能转化,此方法仅供参考,以作记录,以后可能不会这样做了,基本java做中间层转换处理就行了。