oracledblinkmysql報錯ORA-28500

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

連返回值都沒有

聲明：本網頁內容旨在傳播知識，若有侵權等問題請及時與本網聯系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com