OLE DB提供程序“Search.CollatorDSO”返回“命令未准备好” [英] OLE DB provider "Search.CollatorDSO" returns "Command was not prepared"
问题描述
是否有人能够使用SQL Server中的OLE DB Provider for Search连接到Windows Search Service？在下面，您将找到在Management Studio中配置链接服务器时遇到的错误消息。
Has anybody been able to connect to Windows Search Service using the OLE DB Provider for Search in SQL Server? Below you'll find the error message I keep stumbling upon when configuring a Linked Server in Management Studio.
链接服务器TESTSERVER的OLE DB提供程序Search.CollatorDSO返回消息命令未准备好。。
消息7399，级别16，状态1，行2
链接服务器TESTSERVER的OLE DB提供程序Search.CollatorDSO报告错误。命令未准备好。
消息7350，级别16，状态2，行2
无法从OLE DB提供程序Search.CollatorDSO获取链接服务器TESTSERVER的列信息。
OLE DB provider "Search.CollatorDSO" for linked server "TESTSERVER" returned message "Command was not prepared.".
Msg 7399, Level 16, State 1, Line 2
The OLE DB provider "Search.CollatorDSO" for linked server "TESTSERVER" reported an error. Command was not prepared.
Msg 7350, Level 16, State 2, Line 2
Cannot get the column information from OLE DB provider "Search.CollatorDSO" for linked server "TESTSERVER".
我知道在过去几年中有更多的人一直在努力解决这个问题，但我还没有找到解决方案到目前为止。
I'm aware more people have been struggling with this problem over the last few years, but I haven't found a solution so far.
推荐答案
由于只有Microsoft *知道的原因，SQL Server无法访问Windows搜索目录作为OLE DB数据源。此问题唯一可行的解决方法是创建CLR函数并将其用作查询搜索目录的包装器。可以在 http：//找到可立即运行的示例。 www.nesterovsky-bros.com/weblog/2011/03/04/callingwindowssearchfromsqlserver2008.aspx 。
For reasons known only to Microsoft*, the Windows Search catalog is not accessible to SQL Server as an OLE DB datasource. The only feasible workaround for this issue is to create a CLR function and use it as a wrapper for querying the search catalog. A ready-to-run example can be found at http://www.nesterovsky-bros.com/weblog/2011/03/04/callingwindowssearchfromsqlserver2008.aspx.
*我最好的猜测是搜索服务只是部分符合SQL，因为它扩展了SQL-92和SQL-99，但不返回元数据或包含SQL Server预期的数据源的大部分功能。
*My best guess is that the search service is only partially SQL-compliant, in that it extends SQL-92 and SQL-99, but does not return the metadata or contain much of the functionality expected of a data source by SQL Server.
这篇关于OLE DB提供程序“Search.CollatorDSO”返回“命令未准备好”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
