• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Access and Modify SQL Server BLOB Data by Using the ADO Stream Object

Access and Modify SQL Server BLOB Data by Using the ADO Stream Object

The Stream object introduced in ActiveX Data Objects (ADO) 2.5 can be used to greatly simplify the code that needs to be written to access and modify Binary Large Object (BLOB) data in a SQL Server Database. The previous versions of ADO [ 2.0, 2.1, and 2.1 SP2 ] required careful usage of the GetChunk and AppendChunk methods of the Field Object to read and write BLOB data in fixed-size chunks from and to a BLOB column. An alternative to this method now exists with the advent of ADO 2.5. This article includes code samples that demonstrate how the Stream object can be used to program the following common tasks:

Move the contents of a .gif file to an Image column in a SQL Server table.



** Article ID: Q258038 - I take no credit for the code, I simply created a project from the example in the article **

Rate Access and Modify SQL Server BLOB Data by Using the ADO Stream Object

• 1
• 2
• 3
• 4
• 5

(10(10 Vote))

Download Access and Modify SQL Server BLOB Data by Using the ADO Stream Object

Download Access and Modify SQL Server BLOB Data by Using the ADO Stream Object(34 KB)

Access and Modify SQL Server BLOB Data by Using the ADO Stream Object Comments

No comments yet — be the first to post one!

Post a Comment

Subject

Message

0/1000 characters

Post Comment   Clear