当前位置:Gxlcms > mysql > oracledblinkmysql报错ORA-28500

oracledblinkmysql报错ORA-28500

时间:2021-07-01 10:21:17 帮助过:436人阅读

mysqloracle数据库

配置信息如下:求大神支援 支援 支援 重要的事情说三遍
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

连返回值都没有

人气教程排行