RE: PDF iFilter 8/9 with SQL Server?

I managed to fix it. I found a pdf document with instructions on the adobe
site for version 9/ ifilter. I added the adobe bin folder to the path for
the machine and my searches are working now.

"xTom" wrote:

I seem to be having the same problem. did you recieve any answers or find
any solutions?

Thanks.

"Daniel Crichton" wrote:

I currently have the Adobe PDF iFilter v6 working with SQL Server 2005, but
have noticed a number of PDFs are not being returned in searches that should
find them. I believe I've narrowed this down to the v6 Adobe iFilter not
supporting PDF Packages, of which all of these PDFs are. Support for these
appears to be available in the v8 and v9 iFilters, but these iFilters are
not available to download separately from Adobe Reader except in 64-bit
versions, and I'm using 32-bit Windows 2003 with 32-bit SQL Server 2005.
I've installed Adobe Reader 9 on my server, and I can see that the iFilter
is located in:

C:\Program Files\Adobe\Reader 9.0\Reader\AcroRdIF.dll

I've run

exec sp_fulltext_service 'load_os_resources', 1;
exec sp_fulltext_service 'verify_signature', 0;

which should have updated the iFilter definition for .pdf but it's still
showing as

C:\Program Files\Adobe\PDF IFilter 6.0\PDFFILT.dll

and attempting to update this manually with

update sys.fulltext_document_types set path = 'C:\Program Files\Adobe\Reader
9.0\Reader\AcroRdIF.dll' where document_type = '.pdf'

results in the error "Ad hoc updates to system catalogs are not allowed.".

Reading up I can see that I might be able to get around this by restarting
SQL Server 2005 in single user mode and connecting with sqlcmd -A, but as
this is a production server I'd rather not do that unless I know beforehand
that it will work.

I've dug around on the Adobe forums and it appears it might be wasted
effort - there are posts from Adobe stating that the new PDF iFilters are
untested with SQL Server and that they are designed to work with Desktop
Search on Vista and with Sharepoint 2007.

Has anyone managed to get the version 9, or even the version 8, Adobe PDF
iFilter configured with SQL Server 2005 and verified that it does work? I'd
appreciate any hints on how to do this the correct way as I feel that my
attempts to update system tables might be the wrong thing to be trying.

--
Dan



.

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)
  • How to index pdf (Adobe 9) in MOSS 2007?
    ... Getting Adobe IFilter 9 to work with SharePoint ... Since Adobe 8.0 it is included within the Adobe Acrobat and Adobe ... IFilter that is compatible with the latest PDF implementations. ... Download Adobe Reader 9.0 ...
    (microsoft.public.sharepoint.portalserver)
  • Re: PDF custom metadata - available for SharePoint searching?
    ... Adobe PDF iFilter and not the PDF+ iFilter from ifiltershop.com. ... When looking for an IFilter for PDF files, SharePoint first ...
    (microsoft.public.inetserver.indexserver)
  • Re: different search result quoted search office vs pdf
    ... Adobe included the IFilter functionality in Acrobat itself and thus saw no need to create a new independent IFilter for those higher versions. ... However what I really do not understand in my problem is that the pdf appears in the search result, when I switch my IE language settings to en-us. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Custom metadata available for searching?
    ... Adobe PDF iFilter and not the PDF+ iFilter from ifiltershop.com. ... When looking for an IFilter for PDF files, SharePoint first ...
    (microsoft.public.sharepoint.portalserver)
Loading