oracle gateways 连接sqlserver 报错
oracle是装在Linux下的,在装有sqlserver数据库的电脑上安装了gateways,执行了
create database link tjlink
connect to "sa" identified by "topsky"
using '( DESCRIPTION =
( ADDRESS = ( PROTOCOL = TCP )( HOST = 10.108.56.181 )( PORT = 1433 ))
( CONNECT_DATA = (
SID = tj_xlms ) ) ( HS=OK ) ) '
后执行select语句报错
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from tjlink