I'm trying to get the Adobe filer to work on a SQL 2005 x64, but I can't get
it to work.
I have downloaded the bits from
tried to follow the guide as much as I can:-) What I don't understand is why
I would need to install Windows desktop Search on the server but I even
tried that. Exept for the instructions in the page I have run:
EXEC sp_fulltext_service 'load_os_resources',1
EXEC sp_fulltext_service 'verify_signature', 0
Restarted SQL + MSFTESQL
EXEC sp_fulltext_service 'verify_signature', 1
EXEC sp_fulltext_service 'load_os_resources',0
When I run select * from sys.fulltext_document_types I can see that it has
pdf in the list but it is still not indexing. If I look in the log I get the
2008-05-09 15:20:53.76 spid15s The component 'PDFFilter64.dll' reported
error while indexing. Component path 'C:\Program Files (x86)\Adobe\Reader
2008-05-09 15:20:53.76 spid15s Error '0x80004005' occurred during
full-text index population for table or indexed view '[XXXXX].[dbo].[XX]'
(table or indexed view ID '514100872', database ID '26'), full-text key
value 0x0000022C. Attempt will be made to reindex it.
Any help would be nice!