Re: Full-Text Searching



On Feb 29, 2:49 am, Alexey Smirnov <alexey.smir...@xxxxxxxxx> wrote:
On Feb 29, 4:24 am, Cindy <cindyc...@xxxxxxxxxxx> wrote:

Hello and thanks for the previous replies.  Am I to understand that
SQL Server Full-Text Search can not index HTML, PDF, or Word
documents?  What I need is a relational structure, meaning a user
(from the USER table, presumably) will have several documents
associated to him.  Once I find the searched words in a file I get
redirected to the associated user.  Can't I just store each file in an
image field in SQL Server and query it from there?  

Hello Cindy,

yes, you can use a full-text search if your files are stored in the
image field. In this case you don't need any other software, except
the iFilter for PDF indexing. Adobe PDF iFilter lets you index PDF
documents with SQL Server. Starting with Acrobat Reader 7, iFilter
functionality is bundled within the Acrobat Reader and you must
install it (current version is 8) on the server where SQL Server is
installed.

http://www.google.com/search?hl=en&q=full+text+search+files+image+fie....

Index Server would be fine if I only had to search my web site or a
particular directory,

Yes, exactly.

Hope this helps

Say, that's all been very helpful. But now it's time to get to work!
There are a myriad of things to learn; however, once I get something
scalable going I can build from there. It is all really just a set a
very simple problems.

Thanks again!
.



Relevant Pages

  • Re: PDF iFilter install on WSS
    ... I tried the same PDF document on the new ... Maybe I need to wait for iFilter version 7... ... This might have some effect on your ability to search WSS sites. ... If you can't search WSS sites because of SQL Server 2005 Express ...
    (microsoft.public.sharepoint.windowsservices)
  • PDF iFilter 8/9 with SQL Server?
    ... I believe I've narrowed this down to the v6 Adobe iFilter not ... supporting PDF Packages, of which all of these PDFs are. ... SQL Server 2005 in single user mode and connecting with sqlcmd -A, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Full-Text Searching
    ... SQL Server Full-Text Search can not index HTML, PDF, or Word ... Adobe PDF iFilter lets you index PDF ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: PDF iFilter 8/9 with SQL Server?
    ... I believe I've narrowed this down to the v6 Adobe iFilter not ... supporting PDF Packages, of which all of these PDFs are. ... I've installed Adobe Reader 9 on my server, and I can see that the iFilter ... SQL Server 2005 in single user mode and connecting with sqlcmd -A, ...
    (microsoft.public.sqlserver.fulltext)
  • RE: PDF iFilter 8/9 with SQL Server?
    ... I believe I've narrowed this down to the v6 Adobe iFilter not ... supporting PDF Packages, of which all of these PDFs are. ... SQL Server 2005 in single user mode and connecting with sqlcmd -A, ...
    (microsoft.public.sqlserver.fulltext)