Image Data Read From SQL Server Does Not Show Up

Hi Guys,





I've been strugling with this problem all morning today.





Basically I store images in SQL Server 2000 database and then whould like to show them with





<img src="viewImage.aspx?image_id=10" border=1>








My table structure is setup this way





TABLE [userImages] (


[imageFilename] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,


[imageContentType] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,


[imageFileSize] [bigint] NULL ,


[imageFileImage] [image] NULL )








and in viewImage.aspx I have:





if (dr.Read())


{





Response.ContentType = dr.GetString(dr.GetOrdinal("imageContentType"));


Response.BinaryWrite( (byte[]) dr["imageFileImage"] );


}








I have no prolems retrieving the data from DB. But the image does not display(in IE it shows a broken link image)





What's even more puzzling is I CAN display the same image from HDD like so:





FileStream fs = File.OpenRead("D:\my_image.png");


byte[] buffer = new byte[fs.Length];


fs.Read(buffer, 0, buffer.Length);


fs.Close();





Response.ContentType = "application/octet-stream";


Response.BinaryWrite(buffer);








Am I missing something very obvious. I tried playing around with different ContentType's same result.





In my case I am forced to store images in the DB.





I've seen other examples on the net and theirs work. Please help.





Sincerely,


Vlad Orlovsky