
ADO 2.6 problem Can't read BLOB data from Sqlserver 2000 table
We are using the code below and the following happens:
We are using the ADO component to read a binary blob column in a table
the rsStream.Open succeeds
when we try to call the rsstream.read method all we get are ??????
's
we also tried restream.savetofile(c:\bob.txt) and this works fine
using the "read" blob data
anyone met this before?
Dim rsMsg as new adodb.recordset
Dim rsstream as adodb.stream
Set rsMsg = openrecordset(strsql, , adOpenKeyset, adLockOptimistic)
Set rsStream = New ADODB.Stream
rsStream.Type = adTypeBinary
rsStream.Open
rsStream.Write rsMsg.Fields("msgtext1").Value
debug.print rsstream.read