[Closed unsolved] Displaying pictures stored in Database

[sir_jeroen]

Has any1 experencie in displaying pictures that are stored in a database BLOB field?

I set MimeType to "image/jpeg" in Framework Manager and "DisplayType" to "Picture". I also tried MimeType to "image/bmp" and "DisplayType" to "Value".

I'm using SQLServer's Northwind as sample database and I want to display the Employee's photo in the table Employee.

Nothing worked :S

[Darek]

I don't know if you can use BLOBs directly. I believe you will have to develop a servlet or .Net page to return it from the databse as image/jpeg.

[sir_jeroen]

Than can you tell me why there's a mimetype option?
I would say that it would render the request as an image....

[Darek]

We are talking HTML here right? If so, you cannot inject any binary data into HTML output to make an image. You will need to have a servlet, JSP or ASPX page that will set the mime type in an HTML header while returning a BLOB in response to an HTML query.

[sir_jeroen]

Ok.. so I was guessing wrong here :'(
Tnx for your efforts and advice... I'll close the topic now

[ahladia]

Hi Darek;
have you figured out yet how to display a stored Oracle BLOB image that is saved as jpeg, in Report studio?

Dimos