asp+vbscript访问oracle的blob字段 index.asp文件如下
<% @language=VBScript %>
<% Option Explicit %>
<!--#INCLUDE File="adovbs.inc" -->
<%
Dim Conn Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=OraOLEDB.Oracle.1;Password=licheng;Persist Security Info=True;User ID=licheng;Data Source=mydata" Dim rs
Dim sql
dim mMarqueeText sql = "select tp1 from tpxx"
Set rs= conn.execute(sql)
If rs.eof=false then
Response.ContentType = "image/jpeg"
Response.Flush
Response.Buffer = True
Response.BinaryWrite rs(0).getChunk(7500000)
Response.End
End If
rs.close
conn.close
Set conn=nothing
%>
a.html文件如下 <html>
<head>
<title>无标题文档 </title>
</head>
<body>
<IMG SRC=index.asp>
</body>
</html> 为什么不能显示图片,请教各位
<% @language=VBScript %>
<% Option Explicit %>
<!--#INCLUDE File="adovbs.inc" -->
<%
Dim Conn Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=OraOLEDB.Oracle.1;Password=licheng;Persist Security Info=True;User ID=licheng;Data Source=mydata" Dim rs
Dim sql
dim mMarqueeText sql = "select tp1 from tpxx"
Set rs= conn.execute(sql)
If rs.eof=false then
Response.ContentType = "image/jpeg"
Response.Flush
Response.Buffer = True
Response.BinaryWrite rs(0).getChunk(7500000)
Response.End
End If
rs.close
conn.close
Set conn=nothing
%>
a.html文件如下 <html>
<head>
<title>无标题文档 </title>
</head>
<body>
<IMG SRC=index.asp>
</body>
</html> 为什么不能显示图片,请教各位
参考一下。