链接成功:select * from Users@pubs;
uid uname
----------- --------------------------------------------------------------------------------
22 kkkk
但是:SQL> insert into Users@pubs values(5,'hello');
报错:
ORA-28500: 连接 ORACLE 到非 Oracle 系统时返回此信息:
[Transparent gateway for MSSQL][Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: ORA-12154: TNS: 无法解析指定的连接标识符
][Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB 提供程序 'MSDAORA' 报错。 (SQL State: 00000; SQL Code: 7399)
ORA-02063: 紧接着 3 lines (起自 PUBS)
uid uname
----------- --------------------------------------------------------------------------------
22 kkkk
但是:SQL> insert into Users@pubs values(5,'hello');
报错:
ORA-28500: 连接 ORACLE 到非 Oracle 系统时返回此信息:
[Transparent gateway for MSSQL][Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: ORA-12154: TNS: 无法解析指定的连接标识符
][Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB 提供程序 'MSDAORA' 报错。 (SQL State: 00000; SQL Code: 7399)
ORA-02063: 紧接着 3 lines (起自 PUBS)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货