Stream Object in ADO 2.6 to Load/Save Images in SQL Server

Category:
Database
Type:
Applications
Difficulty:
Intermediate
Author:
jayan unni

Version Compatibility: Visual Basic 6

More information:
DEMONSTRATION OF THE USE OF IMAGES(BLOB) WITH SQL SERVER 2000 AND ADO 2.6.

Here is an add, update, delete utility for managing the image data type in sql server 2000. Ilustrates use of the stream object in ADO 2.5 and 2.6.

NOTE: You must change the connection string in the code to match the SQL Server you are using. Including is a T-SQL script to create the table being referenced, or you can change the SQL in the code as well.


Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.

Download blobstream.zip