Image Storage and retrieval

[Steve Head]

I would like to use my sql 6.5 and NT to store and retrieve images.
Any suggestions on getting started?
Anybody with experience in this area?
Any books I can read?

thanks a lot,

Steve head

[billj]

Steve: I recently worked on a project with SQL Server 4.2 and Visual Basic
3.0. We stored scanned signatures from an HP Scanner though our VB apllication
into SQL Server. Depending on the size of the image, you may have to write the
binary data in 'chunks'. We used DBLIB and the IMAGE example included with
DBLIB was very helpful. So far no problems with the images in the database.
Hope this helps.

In article <4uvet1$d...@news.doit.wisc.edu>, jsh...@facstaff.wisc.edu says...

[Neil Pike]

Steve,

If you're talking a seriously large system here, then consider just holding the
name/directory of the image in the db and hold the image on disk.
Alternatively, take a look at Disk Extender from OTG (www.otg.com) which does
exactly this (using SQL Server) and a device driver to make optical jukeboxes
look like NTFS file systems. Even if it's not suitable, looking at how they
have done it may give you ideas.

Neil Pike (neil...@natwestuk.co.uk)
Protech Computing Ltd (MS Solution Provider)
Using Virtual Access 3.50 build 147 (32-bit) on NT 4.0