使用范围查询远程服务器上的索引时出现问题 [英] Trouble querying the index on remote server with a scope
问题描述
我正在尝试查询服务器(Windows Server 2012 r2)上的索引.当我在本地尝试时，没有问题，查询返回一些值，但是当我在systemindex前面添加服务器名称并添加范围时，没有结果.
I'm trying to query the index on a server (Windows server 2012 r2). When I try it locally, there are no probleme, the query return some values, but when i add the server name in front of the systemindex and I add a scope, I have no result.
这是我的代码的示例...
Here is a sample of my code...
昏暗的oconn作为新的OleDbConnection("provider = Search.CollatorDSO; Extended Properties ='Application = Windows';""
oConn.Open()
Dim cmd As New OleDbCommand(选择system.title，system.itemname，system.filename，system.search.hitcount，system.search.rank，System.ItemPathDisplay，system.search.autosummary FROM服务器.SYSTEMINDEX 范围
='file://server/References/'ORDER BY system.filename" ;, oConn)
Dim rdr As OleDbDataReader = Nothing
Dim oConn As New OleDbConnection("provider=Search.CollatorDSO;Extended Properties='Application=Windows';")
oConn.Open()
Dim cmd As New OleDbCommand("SELECT system.title, system.itemname, system.filename, system.search.hitcount, system.search.rank, System.ItemPathDisplay, system.search.autosummary FROM server.SYSTEMINDEX WHERE SCOPE
= 'file://server/References/' ORDER BY system.filename ", oConn)
Dim rdr As OleDbDataReader = Nothing
rdr = cmd.ExecuteReader()
rdr = cmd.ExecuteReader()
同时(rdr.Read())
System.Diagnostics.Debug.WriteLine(rdr(2))
结束时间
While (rdr.Read())
System.Diagnostics.Debug.WriteLine(rdr(2))
End While
感谢您的帮助
Thank you for your help
推荐答案
我正在尝试查询服务器上的索引(Windows Server 2012 r2).当我在本地尝试时，没有问题，查询返回一些值，但是当我在systemindex前面添加服务器名称并添加作用域时，没有任何结果.
您怎么知道防火墙没有阻止入站端口?
How do you know a firewall is not blocking the inbound port?
您什至不知道什么是入站端口?
Do you even know what is the inbound port at all?
您似乎正在尝试访问某种数据库.
It looks like you are trying to hit some kind of a database.
您怎么知道数据库甚至允许与其远程连接?
How do you know the DB is even allowing remote connections to it?
这篇关于使用范围查询远程服务器上的索引时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
