这是完成读取的部分代码。
Public Sub AppendChunkX()
Dim Cn As New ADODB.Connection
Dim rsRead As New ADODB.Recordset
Dim strChunk As String
Dim Offset As Long
Dim Totalsize As Long
Dim ChunkSize As Long Set Cn = New ADODB.Connection
strCnn = "Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=InforReportEffect;Data Source=INFORREPORT;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=INFORREPORT;Use Encryption for Data=False;Tag with column collation when possible=False "
Cn.Open strCnn
rsRead.CursorType = adOpenStatic
rsRead.Open "select img1 from binary", Cn
ChunkSize = 100
Totalsize = rsRead("img1").ActualSize
If rsRead("img1").Type = adBinary Then
Do While Offset < Totalsize
strChunk = rsRead("img1").GetChunk(ChunkSize)
Offset = Offset + ChunkSize
Loop
End If
Debug.Print strChunk
rsRead.Close
End Sub但是在strChunk = rsRead("img1").GetChunk(ChunkSize)老是报错提示:run_error "3219",在此环境中不允许操作。
请高手帮忙解决一下。
谢谢!!
Public Sub AppendChunkX()
Dim Cn As New ADODB.Connection
Dim rsRead As New ADODB.Recordset
Dim strChunk As String
Dim Offset As Long
Dim Totalsize As Long
Dim ChunkSize As Long Set Cn = New ADODB.Connection
strCnn = "Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=InforReportEffect;Data Source=INFORREPORT;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=INFORREPORT;Use Encryption for Data=False;Tag with column collation when possible=False "
Cn.Open strCnn
rsRead.CursorType = adOpenStatic
rsRead.Open "select img1 from binary", Cn
ChunkSize = 100
Totalsize = rsRead("img1").ActualSize
If rsRead("img1").Type = adBinary Then
Do While Offset < Totalsize
strChunk = rsRead("img1").GetChunk(ChunkSize)
Offset = Offset + ChunkSize
Loop
End If
Debug.Print strChunk
rsRead.Close
End Sub但是在strChunk = rsRead("img1").GetChunk(ChunkSize)老是报错提示:run_error "3219",在此环境中不允许操作。
请高手帮忙解决一下。
谢谢!!
解决方案 »
- 急需帮助
- 麻烦刚才帮我发2003文件的朋友重新帮我发下
- 请问各位大哥,如何才能让窗体总是显示在最前。。
- create table SeekResult ( 名次 integer,地区 nvarchar(50),分数 single(8,2))
- 请问一个VB更新Foxpro表的问题
- 袁飞打印预览控件的使用问题,请各位高手解救。
- 各位大仙讲讲vb和MSMQ的连接
- 如何得到已知地址的网页内容,以HTML源码返回,做自动下载用!谢谢!
- 属性框打不开,提示“类没有注册”,这是怎么回事?谁能替我解决??
- 怎么不用Form就能用Timer控件!??高手指教1
- 求获取屏幕某点颜色的另类方法
- 如何同时取得多个坐标点的颜色值?
知悉,若对该字段使用 GetChunk 方法, Field 对象的 Attributes 属性中的 adFldLong 位设置为 True,而attributes属性值好像是只读的。我想是不是应该对adFLdlong赋值?怎么操作?或是其他原因?
Dim rsRead As New ADODB.Recordset
Dim strChunk As String
Dim Offset As Long
Dim Totalsize As Long
Dim ChunkSize As Long Set Cn = New ADODB.Connection
strCnn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=进销存;Data Source=super"
Cn.Open strCnn
rsRead.Open "select fdata from filedb", Cn, adOpenForwardOnly, adLockReadOnly
ChunkSize = 100
Totalsize = rsRead("fdata").ActualSize
If rsRead("fdata").Type = 205 Then
Do While Offset < Totalsize
strChunk = rsRead("fdata").GetChunk(ChunkSize)
Offset = Offset + ChunkSize
Loop
End If
Debug.Print strChunk
rsRead.Close
Cn.Close