Our old PowerBuilder programmers stored a variety of binary files (word, gif, jpg, tiff) in a SQL database IMAGE field, and PB puts OLE header info on the data.
So now we're trying to open those files using ASP. I have no way to know what the type of file is, unless I can decode the OLE wrapper.
I have images stored in a access db and i'm trying to access them like this.
But problem is only one gets displayed. I also cannot get any html on the page since it displays all dots and dashes. Any idea how to solve this.
<%
StrConnect = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../04_db/aspupload.mdb")
Set rs = Server.CreateObject("adodb.recordset")
SQL = "select image_blob from myimages"
rs.Open SQL, strConnect, 1, 3
while not rs.eof
response.binarywrite rs("image_blob")
rs.movenext
wend
rs.Close
%>