使用链接服务器，访问oracle，count(*)出错

Question

通过OraOLEDB.Oracle访问接口创建了SQLSERVER2008R2链接到Oracle11g的链接服务器，然后通过openquery的方式访问oralce数据库

select count(*) from openquery(链接名，'select * from  table '),返回值一直是200

我使用select  * from openquery(链接名，'select * from  table '),返回行数在十几万

select count(某些列) from openquery(链接名，'select * from  table '),返回值 有些列是200，有些列是正确的值。

尝试多种办法没有解决。包括修改访问接口配置等。

盼复，非常感谢。

---

我是甜菜硬木

Answer 1

select  * from openquery(链接名，'select count(*) from  table '),

select  * from openquery(链接名，'select count(某些列) from  table '),

这两种查询方式返回的结果是正常的么？

Answer 2

select  * from openquery(链接名，'select count(*) from  table '),

select  * from openquery(链接名，'select count(某些列) from  table '),

这两种查询方式返回的结果是正常的么？

是的 ，是正常结果。

---

我是甜菜硬木

Answer 3

Hi 甜菜硬木,

这个问题应该和Oracle的驱动有关，你有没有试一下微软提供的驱动，很久之前在Connect上面就有一个类似的问题，你可以参考一下：https://connect.microsoft.com/SQLServer/feedback/details/378087/views-built-based-on-linkedserver-queries-return-wrong

你看下这个，如何获取Microsoft OLE DB Provider for Oracle (MSDAORA)：https://blog.sqlauthority.com/2016/12/17/sql-server-download-microsoft-ole-db-provider-oracle-msdaora-64-bit/ 

Best Regards,

Teige

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 4

Hi 甜菜硬木,

这个问题应该和Oracle的驱动有关，你有没有试一下微软提供的驱动，很久之前在Connect上面就有一个类似的问题，你可以参考一下：https://connect.microsoft.com/SQLServer/feedback/details/378087/views-built-based-on-linkedserver-queries-return-wrong

你看下这个，如何获取Microsoft OLE DB Provider for Oracle (MSDAORA)：https://blog.sqlauthority.com/2016/12/17/sql-server-download-microsoft-ole-db-provider-oracle-msdaora-64-bit/ 

Best Regards,

Teige

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

谢谢，我去试一下。

---

我是甜菜硬木

Answer 5

Hi 甜菜硬木,

你测试了吗，结果如何？

Best Regards,

Teige

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].