2 qq 17491619 qq_17491619 于 2016.02.29 10:09 提问

oracle dblink mysql 报错ORA-28500 5C

配置信息如下:求大神支援 支援 支援 重要的事情说三遍
odbc.ini
[myodbc5]
Driver = /home/oracle/app/myodbc-4.18/lib/libmyodbc5.so
Description = MySQL ODBC 5.1 Driver DSN
SERVER = localhost
PORT = 3306
USER = test
Password = test
DATABASE = test
OPTION = 3
SOCKET =
charset = utf8

tnsnames.ora
myodbc5=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SID = myodbc5))
(HS=OK)
)
listener.ora
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(PROGRAM = dg4odbc)
(SID_NAME= myodbc5)
(ORACLE_HOME= /home/oracle/app/oracle/product/11.2.0/dbhome_1)
(ENVS=LD_LIBRARY_PATH=home/oracle/app/unixodbc-2.2.14)
)
)

 inimyodbc5.ora
 HS_FDS_CONNECT_INFO=myodbc5

HS_FDS_TRACE_LEVEL= ON
HS_FDS_SHAREABLE_NAME=/home/oracle/app/unixodbc-2.2.14/lib/libodbc.so
HS_FDS_SUPPORT_STATISTICS=FALSE
HS_LANGUAGE=AMERICAN.AMERICA.ZHS16GBK

ODBC env variables

set ODBCINI=/home/oracle/app/odbc.ini

创建DBLINK 链接时报错
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from MYODBC5

连返回值都没有

2个回答

himis20091
himis20091   2016.02.29 10:15

删了重新创建一个联邦吧。DB2联邦数据库建立,相当于Oracle的Db-Link

qq_17491619
qq_17491619 我这边就要求用Mysql啊 不让用DB2
接近 2 年之前 回复
qq_17491619
qq_17491619   2016.02.29 10:30

我这边就要求用Mysql啊 不让用DB2

Csdn user default icon
上传中...
上传图片
插入图片
准确详细的回答,更有利于被提问者采纳,从而获得C币。复制、灌水、广告等回答会被删除,是时候展现真正的技术了!