db2是aix环境
在本地已经配好了,odbc连接,测试成功
oracle里面根据
tns配置了:
LinkDb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db2的hostname)(PORT = 50000))
)
(CONNECT_DATA =
(SID = hsdb)
(HS = OK)
)
)
监听:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = HSODBCDB)
(PROGRAM = hsodbc)
(SID_NAME = hsdb)
(ORACLE_HOME = d:\oracle\ora92)
)
)
另外:
HS_FDS_CONNECT_INFO = dbrmb --(dbrmb配置在odbc里面的系统dsn下面)
HS_FDS_TRACE_LEVEL = 0
这两个也配好了,名字是:inithsdb.ora
里面,可是链接建立database link的时候就是提示不通过
create public database link link_sql connect to * identified by * using 'LinkDb';
然后测试这个链接总是报,链接已经关闭,请高手指点,哪里有问题

最新回复
efan (2007-11-14 12:34:50)