我在SQL Server 2008中设置了链接服务器.但我无法对链接服务器运行任何查询.
我试图运行这个简单的命令,但它不起作用
SELECT * FROM MYSERVER..ALANH.TEMP_UPDATE1
这是我运行上面命令时得到的错误.
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "OraOLEDB.Oracle" for linked server "MYSERVER" reported an error. The provider did not give any information about the error.
Msg 7312, Level 16, State 1, Line 1
Invalid use of schema or catalog for OLE DB provider "OraOLEDB.Oracle" for linked server "MYSERVER". A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema.
任何人都可以帮我连接到OracleLinkedServer吗?非常感谢.