各位大虾帮忙啊!(在线等待)
我将本地的一个文件写到sql server中,方法如下。现在的问题是:我上传超过5M的文件时就报告超时错误。WHY??代码如下!另外,我如果用CONNECTIONG,并且设置了TIMEOUT足够大,但还是超时!
Dim Rs As ADODB.Recordset
Set Rs = New ADODB.Recordset
strSql = "select max(id) as maxid from t_bookinfo"
Rs.Open strSql, strCn
bookid = Rs("maxid")
Rs.Close
strSql = "select * from t_bookinfo where id='" & bookid & "'"
Rs.Open strSql, strCn, 1, 3
Dim Buffer() As Byte
Dim flen
flen = FileLen(txtBookPath.Text)
Open txtBookPath.Text For Binary As #1
ReDim Buffer(flen - 1)
Get #1, , Buffer
Rs.Fields("content").AppendChunk (Buffer)
Rs.Update
Rs.Close
Set Rs = Nothing