oracle - 在 SQL Server 2008 R2 中从链接服务器 (Oracle) 运行查询

Question

我在 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？非常感谢。

Answer 1

你也可以这样:

**SELECT * FROM OPENQUERY(MYSERVER, 'SELECT * FROM ALANH.TEMP_UPDATE1')**