Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Full-text search on imported documents

Status
Not open for further replies.

VitoMark

Programmer
Sep 25, 2001
20
0
0
BE
I would like to do a full-text search using SQL Server 2000 on a bunch of documents (.DOC, .XLS).
But I always get an empty resultset.

How did I setup the full-text search?

1) I created an SQL-table with an image-type and a sysname-type column respectively for the content of a document, and for the extension. (columnnames: BLOB resp. Extension); the table also contains a key-column.
2) I Used adodb.stream to import the documents into the SQL-table.
3) I created a catalog
4) I Added the table to the catalog, specifying for column BLOB: the language for word breaker (neutral, or other) and the document type column (Extension).
5) I built the catalog.
But no results in my contains-select.
I've used full-text indexing already for other purposes, but never with imported documents.

Am I trying to do something impossible?
Thankzzzz for support....

 
I think I found the solution. Some of the Word documents where [COLOR=red yellow]out-dated[/color] (Word-2). After re-saving them in a newer Word-2000 format the problem was solved.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top