Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

ORACLE BLOB image ASP

Dear memebr

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
[1311 byte] By [aks44] at [2007-11-11 7:54:30]