Hi
Can somebody pls. tell me what is that Im missing here. Im trying to run queries on remote server where indexing service is running something like this, pls. tell me what else needs to be done
Dim strsearch as string = "select shortfilename,FileName,pat
h,vpath,ch
aracteriza
tion,write
,rank from Scope() where contains ('help')"
Dim objconn As New ADODB.Connection
objconn.ConnectionString = "provider=msidxs; Data Source=query://remoteserve
r/web"
objConn.Open()
Dim objRS As New ADODB.Recordset
objRS.CursorLocation = 3 'adUseClient
objRS.Open(strsearch, objconn, 0, 1)
On local system it works fine when I give connectionstring as "provider=msidxs; Data Source=web"
But on remote system it always gives exception and says There is no catalog. (I checked on remote system also there is same Web catalog and when I run it locally on remoteserver then it runs fine)
Pls. help me in identifying where and what is wrong?
Thanks in advance
Start Free Trial
