Hi, EveryBody,

I want to display pictures stored in a database. First I use the following code(VB6) to save the picture to the database:

Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim stream As New ADODB.stream
Set cnn = New Connection


cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=H:\test.mdb;"
cnn.CursorLocation = adUseClient
cnn.Open
Set rst = New Recordset
rst.ActiveConnection = cnn
rst.Open "t1", cnn, adOpenKeyset, adLockOptimistic
rst.AddNew
rst!p_name = "dd"
stream.Type = adTypeBinary
stream.Open
stream.LoadFromFile "H:\pp.jpg"
rst!pic = stream.Read
Set stream = Nothing
rst.Update
cnn.Close
------------------------------
and then I use the following code(ASP) to display the image:

<%
Dim cnn
Dim rs
' Clear existing HTTP header info
Response.Expires = 0
Response.Buffer = TRUE
Response.Clear

' Set the HTTP header to an image type.
Response.ContentType = "image/JPEG"

cnnPubs=getdbconn() ' the function return the db connection
set rs=server.CreateObject("adodb.recordset")
rs.Open "SELECT FROM t1where id=1",cnn

Response.BinaryWrite rst("pic")
Response.End
%>

and I use <img SRC="getImage.asp"> to show the image.
the first(vb) code works well.
but I alway can not display the image, I just got a image like red X.

please help me to solve the problem.

Thanks a lot!!!


Best!

Alan