[原创]ORACLE GATEWAY FOR SQLSERVER的错误
1.1ORA-02019
SQL> _select* from dbo.sales@dg4msql;
_select* from dbo.sales@dg4msql
*
ERROR at line 1:
ORA-02019: connection description for remote database not found
这个可能是SQLSERVER2000没有打补丁的原因,必须打SP3和SP4补丁
1.2ORA-28500
SQL> _select* from dual@song;
_select* from dual@song
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server
Driver][DBNETLIB]\u04bb\uffff\uffff\uffff\uffff\uffff\uffff\uffff\uffff\uffff\uffff\uffff\uffff\uffff\uffff\uffff\uffff\uffff\uffff\uffff\uffff\uffff\uffff\uffff\uffff\uffff\u0135\uffff\uffff\uffff[Oracle][ODBC SQL Server
Driver][DBNETLIB]ConnectionOpen (PreLoginHandshake()).[Oracle][ODBC SQL Server
Driver]\uffff\uffff\u0427\uffff\uffff\uffff\uffff\uffff\uffff\uffff\u05b7\uffff\uffff\uffff\uffff
ORA-02063: preceding 2 lines from SONG
这个可能是SQLSERVER实例配置不对,可以修改不同配置方法进行测试,
HS_FDS_CONNECT_INFO=host_name/instance_name/database_name
HS_FDS_CONNECT_INFO=host_name//database_name
HS_FDS_CONNECT_INFO=host_name:port_name//database_name
HS_FDS_CONNECT_INFO=host_name/instance_name
HS_FDS_CONNECT_INFO=host_name
举例:
HS_FDS_CONNECT_INFO=10.55.0.139:1433//pubs
HS_FDS_CONNECT_INFO=10.55.0.139//pubs
HS_FDS_CONNECT_INFO=10.55.0.139/songtao/pubs
等等……