Re: Adding PDF indexing with Sql Server 2005

From: Hilary Cotter (hilary.cotter_at_gmail.com)
Date: 01/05/05 

Date: Tue, 4 Jan 2005 22:09:49 -0500

issue the following

sp_fulltext_service 'verify_signature', 0
sp_fulltext_service 'load_os_resources',1

bounce sql server and it should work (provided you have the PDF iFilter
installed). 

-- 
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Steven Paplanus" <sapaplanus@hotmail.com> wrote in message
news:u0j55Zc8EHA.208@TK2MSFTNGP12.phx.gbl...
> I am trying to use the full-text indexes with Sql Server 2005, and wanted
to
> index pdf files.  I have downloaded and installed the Adobe PDF iFilter
from
> Adobe, and have tested it using the iFiltTst on a directory with PDF
files.
> It does index the pdf files.
>
> I then moved the files into a sql server table into a varbinary(max)
field.
> I re-popualted the index, but it is not being indexed.  Also, when I use
the
> "sp_help_fulltext_extensions" command, the ".pdf" extension does not
appear.
>
> Any suggestions on how to get this to work?
>
> Steve
>
>

Relevant Pages

  • Re: More PDF IFilter problems
    ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ... PDF problem remains, however... ... I'm having some frustrating issues with the PDF IFilter and making it ...
    (microsoft.public.sqlserver.fulltext)
  • Re: More PDF IFilter problems
    ... I did generate a new PDF file (which is ... Looking for a SQL Server replication book? ... occurred during full-text index population for table or indexed view ... I'm having some frustrating issues with the PDF IFilter and making ...
    (microsoft.public.sqlserver.fulltext)
  • Re: PDF iFilter install on WSS
    ... This might have some effect on your ability to search WSS sites. ... Unfortunately I don't have SQL Server 2005 so I can't check. ... PDF iFilter works fine with WSS. ... I'm trying to get the Adobe PDF ifilter to work, ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: PDF iFilter 8/9 with SQL Server?
    ... before there were instructions for Sharepoint but nothing for SQL Server. ... app (it's based on the xpdf source code) to handle PDF packages too, ... adobe site for version 9/ ifilter. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: An issue with Full Text Search against PDF blobs...
    ... Looking for a SQL Server replication book? ... Installed Adobe PDF IFilter 6.0 ... Ran a sample query with a string he knows is in the PDF file like the ... Ran the same sample query with a string he knows is in some Word files ...
    (microsoft.public.sqlserver.fulltext)