Re: Adobe filter on SQL 2005 X64

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello Björn,

I don't think this will work with SQL Server.

Try this instead http://sqlblogcasts.com/blogs/simons/archive/2007/07/18/PDF-64-bit-iFilter-at-last.aspx


Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons


I know that - but I don't know what I have done wrong or how I can fix
it:-( Aslo, I'm not sure if it will work, I haven't heard anyone doing
what I'm doing.

Any other sugestions?

Björn

"Hilary Cotter" <hilary.cotter@xxxxxxxxx> skrev i meddelandet
news:C72A88EA-DAB6-409E-B5B5-ADB793466199@xxxxxxxxxxxxxxxx

Thats' a generic permission denied error message. Does that help you
at all?

"Björn Axell" <netnet_46@xxxxxxxxxxx> wrote in message
news:%23uWLwspsIHA.420@xxxxxxxxxxxxxxxxxxxxxxx

Hi,

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
(http://labs.adobe.com/wiki/index.php/PDF_iFilter_8_-_64-bit_Support
and 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
go
EXEC sp_fulltext_service 'verify_signature', 0
go
Restarted SQL + MSFTESQL

EXEC sp_fulltext_service 'verify_signature', 1
go
EXEC sp_fulltext_service 'load_os_resources',0
go
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 following:

2008-05-09 15:20:53.76 spid15s The component 'PDFFilter64.dll'
reported error while indexing. Component path 'C:\Program Files
(x86)\Adobe\Reader 8.0\Reader\PDFFilter64.dll'.

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!

Björn



.

Relevant Pages

  • Re: Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked
    ... I would still try to import the data into your SQL Server instance instead of running linked server queries as you are doing. ... I can query it with no problem and view tabs in Studio. ... EXEC master.dbo.sp_addlinkedserver ...
    (microsoft.public.sqlserver.programming)
  • Re: No more indexing on text
    ... Looking for a SQL Server replication book? ... DROP FULLTEXT CATALOG CmpArchivorCat ... exec sp_fulltext_catalog 'CmpArchivorCat', 'create' ... both text/plain and text/html in my file type column. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Running a DTS Job from a stored procedure
    ... We are running SQL Server 2000. ... -- Create a Pkg Object ... EXEC sp_DisplayOAErrorInfo @oPKG, @hr ...
    (microsoft.public.sqlserver.dts)
  • Re: Error 21776: After creating new login
    ... EXEC DATA0003.dbo.sp_addlogin 'test','pwd' ... > another SQL Server session is not visible to the SQL-DMO session. ... > Jasper Smith ... >> Users collection. ...
    (microsoft.public.sqlserver.security)
  • Re: Auto truncate a string to be inserted to SQL table
    ... EXEC p --Warning was not returned ... Tibor Karaszi, SQL Server MVP ... >> Tibor Karaszi, SQL Server MVP ... >>> message is given...i might need to just truncate the string without halting>>> the process... ...
    (microsoft.public.sqlserver.programming)