Re: Adding PDF indexing with Sql Server 2005

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

From: David Lee (dlee_at_spamking.microsoft.com)
Date: 01/08/05 

Date: Fri, 7 Jan 2005 17:19:57 -0800

This will work, but beware that making this change makes your SQL instance a
little less secure.

Be sure to read the documentation for these flags so you understand the
risk.

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:efcPGQt8EHA.3700@tk2msftngp13.phx.gbl...
> issue the following
>
> sp_fulltext_service 'verify_signature', 0
> sp_fulltext_service 'load_os_resources',1
>
> bounce sql server and it should work (provided you have the PDF iFilter
> installed).
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "Steven Paplanus" <sapaplanus@hotmail.com> wrote in message
> news:u0j55Zc8EHA.208@TK2MSFTNGP12.phx.gbl...
> > I am trying to use the full-text indexes with Sql Server 2005, and
wanted
> to
> > index pdf files. I have downloaded and installed the Adobe PDF iFilter
> from
> > Adobe, and have tested it using the iFiltTst on a directory with PDF
> files.
> > It does index the pdf files.
> >
> > I then moved the files into a sql server table into a varbinary(max)
> field.
> > I re-popualted the index, but it is not being indexed. Also, when I use
> the
> > "sp_help_fulltext_extensions" command, the ".pdf" extension does not
> appear.
> >
> > Any suggestions on how to get this to work?
> >
> > Steve
> >
> >
>
>

Relevant Pages

  • Re: Adding PDF indexing with Sql Server 2005
    ... Looking for a SQL Server replication book? ... > index pdf files. ... I have downloaded and installed the Adobe PDF iFilter ... > It does index the pdf files. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Export Data to PDF (How to?)
    ... >Is there an easy way to export to PDF in DTS SQL 2000. ... I would use Reporting Services (and DTS if required), ... Microsoft SQL Server: ...
    (microsoft.public.sqlserver.dts)
  • Re: SOS!!!!How to config sqlserver to fulltext pdf files?
    ... TextCopy.exe (a utility that ships with SQL Server 2000) to load the PDF ...
    (microsoft.public.sqlserver.fulltext)
  • Search by the description & area name
    ... I just wondering that can I search a pdf files by their description & area ... I can search pdf by the description or files name is simple search. ... I installed pdf iFilter6.0 and SQL Server. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
    (microsoft.public.sqlserver.connect)