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 variablesset 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
连返回值都没有