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....
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....