display a jpeg image stored in an oracle blob

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ret - 30 Jun 2004 09:47 GMT

I have an oracle database connected to access. in access I created a report which shows data about persons. each person has a blob field in the oracle database in which jpeg image data is stored.

how can I display this jpeg image data on an access report in an image control?

Reply to this Message

Exponent - 30 Jun 2004 13:50 GMT

You can create an ADO (or DAO) recordset, then extract the data for each record to a temporary file using
a GetChunk loop, then load the temporary file into an image control.

Alternatively, you can use a 3rd party image control that binds directly to binary image data, such as
our DBPix control. Then you just need to select the control source like any other control.

--
_______________________________________________________
http://www.ammara.com/
Image Handling Components, Samples, Solutions and Info
DBPix 2.0 - lossless jpeg rotation, EXIF, asynchronous

>I have an oracle database connected to access. in access I created a report which shows data about persons. each person has a blob field in the oracle database in which jpeg image data is stored.
>
>how can I display this jpeg image data on an access report in an image control?

Reply to this Message