View Full Version : How View Image Stored in Access DB?
10-30-2003, 03:26 PM
A client has an OLE field called Signature in an Access database. The field contains a GIF image of a scanned signature (that a product has been received).
How can I show this image on an ASP page?
10-30-2003, 04:57 PM
If you can figure out the Content Type maybe:
rsView.Open strSQL, NewConn, adOpenDynamic, adLockOptimistic
On error Resume Next
If Not rsView.EOF Then
If err.Number <> 0 Then
10-30-2003, 07:27 PM
See this thread: http://www.codingforums.com/showthread.php?s=&threadid=23667
More threads on this subject are available by searching this forum for the word BLOB.
11-03-2003, 09:50 AM
Basically it all comes back to the fact that this can be done with a database like SQL Server (with its blob field) but not Microsoft Access (with its OLE field). But thank you for your responses!
11-04-2003, 08:48 PM
I beg to differ... ;)
The first URL only covers Paintbrush files, but the basic principle is sound - simply skip to the real data using the header information from the second link. And no ActiveX is needed - you can do all this very efficiently in VBScript by using use the ADO.Stream object for fast binary data manipulation.
01-05-2004, 09:42 PM
See this (http://www.codingforums.com/showthread.php?s=&threadid=23667) thread for more information on handling blobs from ASP.
Powered by vBulletin® Version 4.2.2 Copyright © 2017 vBulletin Solutions, Inc. All rights reserved.