conn.asp
<%
dim conn
dim connstr
call connstart()
Response.CacheControl = "no-cache"
sub connstart()
connstr="driver={sql server};server=(local);uid=sa;pwd=hicc;database=zbx"
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr
if err.number<>0 then
set conn=nothing
response.write "数据库连接出错!"&err.description
Response.End
end if
end sub
sub connend()
conn.close
set conn=nothing
end sub
%>
img.asp
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body>
<form name="mainForm" enctype="multipart/form-data" action="upload.asp" method=post>
<input type="file" id="zbx" name="zbx" />
<input type="submit" value="ok!" />
</form>
</body>
</html>
upload.asp
<!--#include file="conn.asp" -->
<%
response.buffer=true
formsize=request.totalbytes
formdata=request.binaryread(formsize)
bncrlf=chrB(13) & chrB(10)
divider=leftB(formdata,clng(instrb(formdata,bncrlf))-1)
datastart=instrb(formdata,bncrlf & bncrlf)+4
dataend=instrb(datastart+1,formdata,divider)-datastart
mydata=midb(formdata,datastart,dataend)
set rec=server.createobject("ADODB.recordset")
rec.Open "SELECT * FROM [img]",conn,1,3
rec.addnew
rec("img").appendchunk mydata
rec.update
rec.close
set rec=nothing
set connGraph=nothing
%>