Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002

    Unanswered: text search on files with SQL Server


    I'm trying to do some experiments on how to search for words or expressions in a knowledge-base(full-text search is how it's called)

    I would like to place my files in the file system and not in the DB. It seems as if SQL Server 2000 needs MSIDXS to search in the file system. But I don't really know how to use all of this.

    When I try this request:
    OPENQUERY(TEST_IX_JD,'SELECT DIrectory from SCOPE('' "D:\" '')
    WHERE CONTAINS(''"SQL Server" NEAR() text'')
    AND FileName LIKE ''%.doc%''')

    I have this error:
    Server : Msg 7320, Level 16, State 2, Line 1
    Cannot execute the request on the provider OLE DB 'MSIDXS'.
    [OLE/DB provider returned message: There's no catalog. ]

    (or something like that. the following is the original:
    Serveur*: Msg 7320, Niveau 16, État 2, Ligne 1
    Impossible d'exécuter la requête sur le fournisseur OLE DB 'MSIDXS'.
    [OLE/DB provider returned message: Il n'y a pas de catalogue. ]

    Does somebody knows why?

    The same question but asked differently:
    Does somebody knows how to do some full-text search on documents located in the filesystem, with SQL Server 2K? I know I'll have to use Microsoft Indexing Service, but I don't know how to do it.

    (I'm new with SQL Server, so please be patient and explain me in detail)
    Last edited by Uncle Bob; 07-05-02 at 05:41.

  2. #2
    Join Date
    Jul 2002
    Actually, it doesn't seem really possible, since SQL Server2K(requests in DB) and Index service(searches in the file system and web) are 2 separate things. There's one software that does the mix, it's Sharepoint. What I understood is that sharepoint enables DB SQL requests and file search in the file sytem, and maybe more.

    If some of you are interested in MS index service, you shoul see those 2 adresses:
    (explains the whole)

    (explains the procedure);EN-US;q308202

    Uncle Bob

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts