oracle10g通过透明网关连接sql2000的问题 急!
hh302 2009-12-28 12:07:09 C:\oracle\product\10.2.0\tg_1\tg4msql\admin
HS_FDS_CONNECT_INFO="SERVER=10.0.0.8;DATABASE=pubs"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
C:\oracle\product\10.2.0\tg_1\tg4msql\admin\listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\tg_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = tg4msql)
(ORACLE_HOME = C:\oracle\product\10.2.0\tg_1)
(PROGRAM = tg4msql)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.51)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
C:\oracle\product\10.2.0\db_1\tg4msql\admin\tnsnames.ora
sql2k =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.51)(PORT = 1521)) #此处HOST填的是透明网关SERVER的地址
)
(CONNECT_DATA = (SID = tg4msql) ) #此SID应和透明网关SERVER上设定的SID相同
(HS=OK)
)
SQL> select * from t@tosql2k;
select * from t@tosql2k
*
第 1 行出现错误:
ORA-28500: 连接 ORACLE 到非 Oracle 系统时返回此信息:
[Transparent gateway for MSSQL][Microsoft][ODBC SQL Server Driver][SQL
Server]用户 'PDA' 登录失败。原因: 未与信任 SQL Server 连接相关联。 (SQL State:
00000; SQL Code: 18452)
ORA-02063: 紧接着 2 lines (起自 TOSQL2K)
我的oracle10g和透明网关装在一台机器上10.0.0.51 sql server2000装在10.0.0.8上 tnsping 是成功的 lsnrctl start也没有错误
就是运行就报用户 'PDA' 登录失败。原因: 未与信任 SQL Server 连接相关联,以前是'sa'用户,换了个用户也没用,有谁知道怎样
解决吗??!!!