PDF iFilter 8/9 with SQL Server?
- From: "Daniel Crichton" <msnews@xxxxxxxxxxxxxxxx>
- Date: Thu, 15 Jan 2009 10:05:36 -0000
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
.
- Prev by Date: Re: SQL SERVER 2008 Create FullText stoplist table Failed
- Next by Date: Full Text Search across multiple tabels in SQL 2005/2008
- Previous by thread: HELP: SQL SERVER 2008 Create FullText stoplist table Failed
- Next by thread: Full Text Search across multiple tabels in SQL 2005/2008
- Index(es):
Relevant Pages
|
Loading
