store multipage image in database

Hi! I read Mytch's articles about blobbing with php and mysql. I am actually trying to do the same thing with a VB application and SQL Server 2000. I basically stream the image into the database and it works fine for one page images (the images being reports scanned so they could be many pages). It seems this isn't working for those images where there are more than one page. Anyone ever dealt with this? Thanks!

Are you working with multipage tiff images?

Also, I must ask... why are you blobing multipage tiffs to a database? Without even knowing the nature of your business, I can pretty much guess that your images are on average at least 1-2mb in size each.

I won't go into too much detail about how slow this will be, but just know that it won't be optimal.

Are you don't this for a specific reason or are you doing it just because you can?

Hi laidbak,

Yes, I am working with multipage tiff images. I know that storing the images in the database is slow, but that is what I have to work with. I am helping a doctor make a program to insert some data (including the image) into a database that is used by software that he uses. The software will then be used to view the data. Because the software stores the image in the database and is expecting it to be there, I don't have any other choice. Any ideas would be appreciated.

I don't follow - why exactly can't you store the images to the filesystem?

We have to store the images in the database because we are using commercial software to retrieve it and that is the way the software does it. If I don't store the image, the software won't be able to display the images. Any suggestions?

Thanks for your time everyone. The problem has been identified. I checked the size of the stream object and it was the same size as the image so all of the image was being included. Apparently, the commercial software that we were also working with has just released a fix for the bug "multi-page reports show only the first page." Kind of frustrating to keep banging my head on this trying to figure it out and then the company release a fix because the problem was on their end. Oh well, at least it is fixed.