PDF IFilter with sql server 2008

[kamelkb]

Hi,

I am testing a new solution in my compagnie. I have to setup a full text search in pdf document.

I have some questions :

1- Foxit pdf IFilter works with sql server 2008 ?
2- if i install the filter for testing in server os (windows 2008), it works or not ?

Thank you for the answer

[kamelkb]

it seems it works. Here it is the steps i did (if someone meet the same pbm ) :

1- i have windows server 2008 and sql server 2008
2- i installed acrobat reader
3- i installed the Foxit PDF IFilter
4- i ran those commands in the console SQL Server 2008 :
exec sp_fulltext_service 'load_os_resources', 1
exec sp_fulltext_service 'verify_signature', 0;
5- I restart the sql service
6- i ran those commands in the console SQL Server 2008 :
exec sp_fulltext_service 'update_languages';
exec sp_fulltext_service 'restart_all_fdhosts';
7- I check if the filter is installed :
select document_type, path from sys.fulltext_document_types where document_type = '.pdf'

8- I create my catalogue
9- I create my full-text index and link it with the catalogue i already created.
10- I started the full Population

And now the search works !!

[christina]

Thanks for sharing.

[parkar.leonardo]

Hi,
Recently I discovered that Adobe finally came out with a new Adobe iFilter 9 for 64-bit platforms which allows searching PDF files on 64-bit Windows platforms for MOSS 2007, Exchange 2007, and SQL Server 2005. I tried this new iFilter and was able to get it to work. I decided to document these instructions for people who may be running MOSS 2007 on Windows Server 2008.

-------------------------------------------------------------
Email Autoresponder Software
" Hard work is doing the "hard part" of the work, which means going the extra mile."

[lzPDF]

Foxit IFilter is perfect, I try to using Adobe PDF IFilter,but when i test it I found it crash when used in mulit-thread mode,Foxit PDF IFilter is perfect.