All i wanna do is simple, I wanna display an image from an access database.

I try alot of things to no result. Like ascii code or nothing but a blank image with a red 'X'.

Here is the code :

<%
set conn=server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.jet.oledb.4.0"
conn.Open(server.MapPath("test1.mdb"))
set rs= conn.Execute("SELECT photo FROM photos where ID=1")
Response.ContentType="image/jpg" 
Response.BinaryWrite(rs("photo"))
conn.Close 
%>

I also tried a file named ShowPicture.asp and call it from another file like this:

<IMG SRC="ShowPicture.asp?PhotoId=1">
[I]ShowPicture.asp[/I]
<%
'Declare Variables
Dim sql
Dim rs
Dim conn
Dim userID,str
 
userID = Request("PhotoId")
If userID = "" Then userID = 0
 
'Instantiate Objects
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
 
'Open connection
conn.Provider="Microsoft.jet.oledb.4.0"
conn.Open(server.MapPath("test1.mdb"))
 
'Get the specific image based on the ID passed in a querystring
str = "SELECT photo FROM photos where ID =" & userID
rs.Open str, conn,3,3
 
if rs.eof then 'No records found 
Response.End
else 'Display the contents
Response.ContentType = "image/jpg" 
Response.BinaryWrite(rs("photo")) 
end if
 
'destroy the variables.
rs.Close
conn.Close
set rs = Nothing
set conn = Nothing
%>

I also try this :

<body>
<%
set conn=server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.jet.oledb.4.0"
conn.Open(server.MapPath("test1.mdb"))
set rs= conn.Execute("SELECT photo FROM photos where ID=1")
Response.ContentType="image/jpg"
%>
 
<img src="<%Response.BinaryWrite(rs("photo"))%>">
 
<% conn.Close %>
</body>

All i got is tons ascii codes.

Can you help me on this ?

thanx
Chris

Recommended Answers

All 6 Replies

Hi there,

I hope this code will help you!

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
database = Server.MapPath("/files.mdb")

set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open database

        SQL = "SELECT * FROM Files WHERE FileID = 3" 
        Set Rs = conn.Execute(SQL)
        Response.BinaryWrite Rs("BinaryData").GetChunk(Rs("BinaryData").ActualSize)
 %>

Best regards,
Rahul Dev

It give me the same things again. Did you test the code ?

Ascii codes :sad:

thanx

Hi Again,

Yes I did test that code and its working :)

Well have look at these

This file

1.) img.asp

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
database = Server.MapPath("DATABASE.mdb")

set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open database

    SQL = "SELECT * FROM Files WHERE FileID = 3" 
    Set Rs = conn.Execute(SQL)
    Response.BinaryWrite Rs("BinaryData").GetChunk(Rs("BinaryData").ActualSize)
        
%>

2.) imageDis.asp

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>For Help</title>
</head>
<body>
<img src="img.asp" />
</body>
</html>

3.) img1.asp

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
database = Server.MapPath("DATABASE.mdb")

set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open database

Dim SQL
Dim FileID

FileID = 4

SQL = "SELECT * FROM Files WHERE FileID = " & FileID

Set Rs = conn.Execute(SQL)
If Not Rs.EOF Then

  Response.AddHeader "content-disposition", "inline; filename=" & oRs("FileName")
  Response.AddHeader "content-length", Rs("BinaryData").ActualSize
  Response.ContentType = Rs("ContentType")
    
  Response.BinaryWrite Rs("BinaryData")
    
Else

  Response.Write("File could not be found")
    
End If        
%>

Examples:

This file will give output in ASCII codes
1.) http://www.katarey.com/forhelp/img.asp

And this file will show the image,
2.) http://www.katarey.com/forhelp/imageDis.asp

I hope This file that you want!
3.) http://www.katarey.com/forhelp/img1.asp


I hope this will helpful for you, please feel free to ask question if any :)

Thanks
Regards,
Rahul Dev

First, Thank you for your help ;)

But the problem persist, I again get some ascii codes but I don't think its the asp code.

When i put some picture in access database , access give them the type : package. I think it is the source of the problem because I have another database that I download from the internet where picture's type are long binary data and I can display them correctly with your code.

Can you show me how to put long binary type in access database ?
I try to convert but there is no other choice in the convert list.

thanx

Hello Sir,

I too have the same problem. Have u got the solution?

Thanks..

You have to read the picture into IO stream. Probably FileStream then convert the picture data into binary data (Byte array).

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.