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:
SELECT * FROM
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)
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.