Problems indexing PDF documents with Foxit iFilter on SQL Server 2008

• mober

  Valued Member

  Points: 51

  More actions

  February 22, 2013 at 2:50 am

  #271242

  I have a SQL Server database and want to index PDF documents in the database. I use the Foxit iFilter. The iFilter is already installed but after indexing the file table the log consists of a huge amount of error messages like

  "Warning: No appropriate filter was found during full-text index population for table or indexed view ...."

  I also think that the iFilter was installed correctly. When I execute

  [font="Comic Sans MS"] select * from sys.fulltext_document_types order by document_type[/font]

  there is one entry for PDF as document_type and the correct path to PDFFilt.dll

  What could be the reason, that the filter is not found during the index process however?

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  March 2, 2013 at 6:07 pm

  #1592719

  One, is there a reason you did not provide the entire test of the error message?

  Two, just a shot in the dark, but have you checked the permissions on the folder and dll file to be sure SQL could actually access it?