locked
WSS Search Service stops when using scopes RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Im using FullTextSqlQuery to query my sharepoint site. It works fine when used in the following manner

    QueryText = "SELECT Title,Path FROM SCOPE() where Title = 'Test'";

    However as soon as I use scopes, it returns an error "Cannot connect to the Search Service" and the WSS Search Service crashes. It  has to be manually restarted.

    QueryText = "SELECT Title,Path FROM SCOPE() where \"scope\" = 'All Sites'";

    Thanks in advance

    • Moved by Mike Walsh FIN Friday, July 1, 2011 8:01 AM clearly a search question so what is it doing in the programming forum? (From:SharePoint - Development and Programming (pre-SharePoint 2010))
    Friday, July 1, 2011 6:13 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    Got the solution. Switching Microsoft.SharePoint.Search.Query.FullTextSqlQuery with Microsoft.Office.Server.Search.Query.FullTextSqlQuery did the trick.
    • Proposed as answer by Rashu,Rahul Friday, July 1, 2011 5:22 PM
    • Marked as answer by David HM Friday, July 8, 2011 1:40 AM
    Friday, July 1, 2011 10:52 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Do you have appropriate permissions on the SharePoint Search Service?
    -
    Please try using the SharePoint Search Service Tool to test the FullTextSqlQuery class.
    http://sharepointsearchserv.codeplex.com/
    --Cheers
    Friday, July 1, 2011 6:42 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Got the solution. Switching Microsoft.SharePoint.Search.Query.FullTextSqlQuery with Microsoft.Office.Server.Search.Query.FullTextSqlQuery did the trick.
    • Proposed as answer by Rashu,Rahul Friday, July 1, 2011 5:22 PM
    • Marked as answer by David HM Friday, July 8, 2011 1:40 AM
    Friday, July 1, 2011 10:52 AM