[原创]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

等等……