Retrieving Images (jpg and gif) from MS Access DB 
Author Message
 Retrieving Images (jpg and gif) from MS Access DB

Hi !

Does anyone know, how to retrieve an JPG or GIF Image from an MS Access
Database and display it.
I tried a lot of things but couldn't get a result.

I hope someone of your guys out there can help me with this question !

Thanks

Efkan



Mon, 04 Sep 2000 03:00:00 GMT
 Retrieving Images (jpg and gif) from MS Access DB

Quote:

> Hi !

> Does anyone know, how to retrieve an JPG or GIF Image from an MS Access
> Database and display it.
> I tried a lot of things but couldn't get a result.

> I hope someone of your guys out there can help me with this question !

> Thanks

> Efkan

I don't think you can retrieve a picture in a resultset.  What you could
do is store the URL path in the database and use it in conjuction with
an image object on your applet.

Dave



Fri, 08 Sep 2000 03:00:00 GMT
 Retrieving Images (jpg and gif) from MS Access DB


Quote:
>I don't think you can retrieve a picture in a resultset.  What you could
>do is store the URL path in the database and use it in conjuction with
>an image object on your applet.

Actually, you can do it. Use the getBinaryStream() method in your
ResultSet. Then, you can use the stream you get back to read the image
data into a byte array. Then, you can use the createImage() method in
Toolkit.

Good luck,
Tony

--
Anthony W. Erwin, SLIS Grad Student
Graduate Assistant, IU Center for Excellence in Education
http://www.cs.indiana.edu/hyplan/aerwin.html
"In basketball, the mental is to physical as four is to one." -Bob Knight



Fri, 08 Sep 2000 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Storing/Retrieving a GIF image from a SQL DB Table

2. IMAGE data (jpg/gif) -> Picture in application

3. Reading/Writing JPG and GIF Images from/to the RDBMS

4. Storing Images (jpg, gif, etc) On Oracle 7.3.4.5.0 Database

5. Bcp'ing in jpg, gif, etc image files

6. GIF or JPG images in a report

7. Images (Jpg,Gif,Tif etc...) in VFP

8. GIF & JPG Images

9. Image Scan/Resize/Save as JPG or GIF??

10. Save and read .jpg images from and to Access db

11. Problems with GIF/JPG-Graphics with the Access-JetEngine in VB5.0

12. Storing/Retrieving images within Access 2000 DB


 
Powered by phpBB® Forum Software