Dear Freinds,
I tried my best, Here i need Help to solve my problem.
My code:
<%@ Language=VBScript %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<%
set conn=server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.jet.oledb.4.0"
conn.Open(server.MapPath("picture.mdb"))
set objrs=objconn.Execute("select picture from picture whrere ID=1")
Response.ContentType="images/bmp"
Response.BinaryWrite(objrs("picture"))
conn.Close
%>
</BODY>
</HTML>
Please give me a immediate solution.please....
There was only some little errors
try this
<%
set conn=server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.jet.oledb.4.0"
conn.Open(server.MapPath("picture.mdb"))
set objrs=conn.Execute("select picture from picture where ID=1")
Response.ContentType="images/bmp"
Response.BinaryWrite(objrs("picture"))
conn.Close
%>
Ok but now I try this code with images/jpg or jpeg for my example:
<%
set conn=server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.jet.oledb.4.0"
conn.Open(server.MapPath("test1.mdb"))
set objrs= conn.Execute("SELECT photo FROM photos where ID=1")
Response.ContentType="images/jpeg"
Response.BinaryWrite(objrs("photo"))
conn.Close
%>
The only thing I got is tons of ascii characters like this : $˙˙˙˙PackagePackage...
Can anyone help ??