Index Tiff images using Sql Server 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sohaib - 27 Jul 2006 13:34 GMT

I want to Index Tiff images by using Sql Server 2000.
But i couldn't find any IFilter for indexing Tiff Images.
Can anyone help?

Reply to this Message

Michael Epprecht [MSFT] - 27 Jul 2006 13:48 GMT

Hi

SQL Server 2000 and 2005 do no ship with a TIFF filter. As TIFF is an image,
OCR needs to be run against the contents of the file.

Have a look at
http://jtkane.spaces.msn.com/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!374.entry for
your options.

Regards

Signature

Mike

This posting is provided "AS IS" with no warranties, and confers no rights.

>I want to Index Tiff images by using Sql Server 2000.
> But i couldn't find any IFilter for indexing Tiff Images.
> Can anyone help?

Reply to this Message

Hilary Cotter - 27 Jul 2006 14:29 GMT

Office XP and above ship with the MSPaper.dll iFilter for handling tiff
files.

Check this registry key - HKEY_CLASSES_ROOT\.tiff\PersistentHandler

If the value is {58F2E3BB-72BD-46DF-B134-1B50628668FB} you have the correct
iFilter installed.

If not you would need to install this on your server to get it to work.
Bring up a tiff file in Microsoft Office Document Imaging, double click on
the OCR button (the eye) and install this feature.

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

>I want to Index Tiff images by using Sql Server 2000.
> But i couldn't find any IFilter for indexing Tiff Images.
> Can anyone help?

Reply to this Message

Sohaib - 27 Jul 2006 15:42 GMT

Hi Hilary Cotter,
Thanks...
Yes MSPaper.dll exists on my system and also i hv checked

Microsoft Office Document Imaging (MODI) OCR
functionality its working well
MODI is using Indexing services to Index Tiff images. But
I want to use
Sql Server 2000 to index tiff images.
As "Michael Epprecht" is saying that sql server 2000 does
not contain IFilters
Tiff Images. But i hv experience that Microsoft Share
Point Server can index
Tiff Images. But i m clear with it whether it is using
indexing services or Tiff
Tiff IFilter. If anyone knows about it plz clear it ....

> Office XP and above ship with the MSPaper.dll iFilter for handling tiff
> files.
[quoted text clipped - 25 lines]
> > But i couldn't find any IFilter for indexing Tiff Images.
> > Can anyone help?

Reply to this Message

Sohaib - 27 Jul 2006 15:53 GMT

Hi Hilary Cotter,
Thanks...
Yes MSPaper.dll exists on my system and also i hv
checked
Microsoft Office Document Imaging (MODI) OCR functionality its working
well. MODI used Indexing services to Index Tiff images. But I want to
use Sql Server 2000 to index tiff images. As "Michael Epprecht" is
saying that sql server 2000 does not contain IFilters
for Tiff Images. But i hv experience with Microsoft Share Point Server.
SPS can index
Tiff Images. But i m not clear with SPS whether it is using Windows
indexing services or Tiff IFilter. If anyone knows about SPS IFiltering
plz clear it ....

> Hi Hilary Cotter,
> Thanks...
[quoted text clipped - 42 lines]
> > > But i couldn't find any IFilter for indexing Tiff Images.
> > > Can anyone help?

Reply to this Message

Hilary Cotter - 28 Jul 2006 01:49 GMT

both indexing services, sharepoint, exchange, and SQL server full-text
search can use the tiff ifilter.

Hilary

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi Hilary Cotter,
> Thanks...
[quoted text clipped - 60 lines]
>> > > But i couldn't find any IFilter for indexing Tiff Images.
>> > > Can anyone help?

Reply to this Message

Sohaib - 28 Jul 2006 07:41 GMT

ok i agree that Indexing Services, sharepoint, exchange can use Tiff
IFilter.
But its not clear to me that how can Sql Server Full Text Search use
Tiff IFilter.
What are its requirements .???

> both indexing services, sharepoint, exchange, and SQL server full-text
> search can use the tiff ifilter.
[quoted text clipped - 73 lines]
> >> > > But i couldn't find any IFilter for indexing Tiff Images.
> >> > > Can anyone help?

Reply to this Message