Hi,

I read all threads regarding this issue over here. but still not able to solve the problem.

I am using SQL Server 2000 database. and my table contains 2 pictures in each record.

I want to display image in .asp page, but not working.

My code is as below. I tried as you mentioned, but I am getting junk data, not image as output.

<%
Dim Cart_M

set Cart_M = Server.Createobject("ADODB.RecordSet")

Cart_M.ActiveConnection = MM_DB_STRING

Cart_M.Source = "Select CartName, Picture1, Picture2 From Cart_M Where CartName = '3M81-3C071-AD'"

Cart_M.open

If Not(Cart_M.EOF) Then

response.ContentType = "image/bmp"
response.binarywrite cart_m("picture2")

End if

Cart_M.close
%>