Solved

PDF ifilter installed for full Text Search but search returns empty in SQL 2005 FTS

Posted on 2008-06-19
5
428 Views
Last Modified: 2012-06-22
Just installed the PDF ifilter in SQL 2005 and created Full Text indexes for several comumns on a table. One of the columns contains pdf documents and is data type image. the others are nvarchar . Sull text searches return correctly on the nvarchar fields but the field containing the PDF document returns empty.

I ran the exe install from ADobe and manually registered the PDF filter. any suggestions would be greatly appreciated.
Thanks!
0
Comment
Question by:pete5950
  • 3
  • 2
5 Comments
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 21824240
As per http://support.microsoft.com/default.aspx?scid=kb;en-us;945934 
3.      In SQL Server Management Studio, select the instance in which you want to enable IFilters, and then run the following command in that instance:
sp_fulltext_service 'load_os_resources', 1
4.      If you are running SQL Server 2008, go to Step 5. If you are running SQL Server 2005, stop and restart the msftesql service. To do this, follow these steps:
a.       At a command prompt, type the following command and then press Enter:
net stop msftesql
Note To stop the msftesql service for a specific instance, run the following command:
net stop msftesql$InstanceName
b.       At a command prompt, type the following command and then press Enter:
net start msftesql
Note To start the msftesql service for a specific instance, run the following command:
net start msftesql$InstanceName

5.      Restart the SQL Server service.

0
 

Author Comment

by:pete5950
ID: 21824587
I did these things and have the same result. The query I am running is in Query Analyzer:

SELECT * FROM ContainsTable([editionArticle], pdf, '"Sale"') and returns empty.

a similar query run agains a nvarchar field "SELECT * FROM ContainsTable([editionArticle], Title, '"Supertest2"')" returns the Primary key and a rank.
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 21824620
it worked for me
0
 

Author Comment

by:pete5950
ID: 21825209
Thanks emoreau, I wish it had worked for me. There is probobly something stupid and simple that I am missing. I do appreciate the input. THANKS :-)
0
 

Accepted Solution

by:
pete5950 earned 0 total points
ID: 21876929
After looking at all of the variables several times, and following the advice here , at Microsoft and a few other locations and trying it on two different servers without results, I changed the data type on the column storing the PDFs from image to varbinary and it began working immediately.
It is fast an solid and a truely marvelous thing.
Thanks for your help.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Clear out MSDB file in sql server 2 30
SQL server 2012 BPA and Baseline Configuration Analyzer 2.0 16 27
Star schema daily updates 2 33
SQL Syntax 6 36
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question