I just found my own answer. I would still like any addtional input or critique of this procedure.
you have to first add a com reference "Microsoft ActiveX data object 2.8 library"
create a datasource and a record set add the name of the stored procedure and the SP's parameter value.
SP's sql = select * from blob_files where blob_id = @blob_id
myConn.Open()
Recordset.SelectCommand = metadataCMD
Recordset.Fill(ds)
Dim BlobStream As New ADODB.Stream
BlobStream.Type = ADODB.StreamTypeEnum.adTypeBinary
BlobStream.Open()
BlobStream.Write(ds.Tables(0).Rows(0)(ds.Tables(0).Columns.Item(
"blob_col").Ordinal))
BlobStream.SaveToFile(
"C:\Inetpub\wwwroot\test.ppt")
also just to be clear i worte this as a sub procedure in vb.net inside of my webpage.