ADO 2.6 problem Can't read BLOB data from Sqlserver 2000 table 
Author Message
 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



Sat, 06 Sep 2003 07:45:26 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. ADO 2.0 to 2.6, Window 98, NT and 2000

2. HELP: output parameter in a SP ( SQL 2000, ADO 2.6)

3. ADO 2.6 and SQL 2000

4. ADO 2.6 Error Collection and SQL Server 2000

5. 'Canned' data in VB program

6. MSSQL Temp tables and ADO 2.6

7. Can't get help to come up with ADo 2.6 on VB 6

8. Access 2000 can't read from a referenced table - but could in Access 97

9. ADO 2.6 and Oracle 8.1.6 - column data missing when opening a recordset

10. Data access on AS400 via ADO 2.6

11. Data access on AS400 via ADO 2.6

12. Problem reading/writing BLOB data with RDO

 

 
Powered by phpBB® Forum Software