iFilter is free, but Indexing service will consume CPU on server.
as for query:
strQuery = "Select DocTitle,Filename,Size,PATH,URL, DocComments from SCOPE() where CONTAINS(' """ & SearchText & """ ')"
''// extra search
strQuery &= " OR CONTAINS(DocComments, ' """ & SearchText & """ ')"...
If objective is to search text in PDF files
and IIS and SQL server are used
then try this:
Enable Index services.
Get iFilter from Adobe web site for indexing pdf files.
FREETEXT searching will find files with key words.
Just got these two books recently from amazon. They are really good. The first one has more details while the second one gives a good guideline.
The Definitive Guide to the .NET Compact Framework
Paperback 1011 pages (November 2003) Publisher: Apress ISBN: 1590590953
Building...
"Invalid Table Number" :
make sure Database Driver match 'Server Name'.
For ODBD connection ServerName is supposed to be DSN name.
I have no problem using pdssql.dll (SQL server).
yuhui
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.