ORACLE BLOB image ASP
Please help me in ORACLE BLOB image loading in ASP.
i m using folloing code to display Oracle BLOB image
<% @language=VBScript %>
<% Option Explicit %>
<!--#INCLUDE File="adovbs.inc" -->
<%
Dim Conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=OraOLEDB.Oracle.1;Password=ora2;Persist Security Info=True;User ID=ora22r;Data Source=OPPS"
Dim rs
Dim Sql
dim mMarqueeText
Sql = "Select Photo from EMPLOYEEPHOTO"
Set Rs= conn.execute(sql)
If rs.eof=false then
Response.ContentType = "image/jpeg"
'Response.Flush
Response.Buffer = True
Response.BinaryWrite rs(0)
Response.End
End If
Rs.close
conn.close
Set conn=nothing
and call this file from another asp file using fowwloing way
<IMG SRC=abovefile.asp>
It works well in Internet Explorer 5.0 but in case of IE6 i found a problem :
If picture (JPG) size < 20 KB then it doesn't show image and just display
cross image Frame (without image).
Will u any please let me knwo about the actual problem
Thanking U
have a fun!
Ashok

