Read binary record from Database with ADODB.Stream

[guyv]

Hello!

I wanna read binary data from database with ADODB.Stream object.
So I wrote code..

---------
<%
query = "SELECT * FROM Categories"
adoDB.DefaultDatabase = "Northwind"

adoRs.Open query, adoDB, 1

Set rec = Server.CreateObject("ADODB.Record")

'read [Picture] column.
rec = adoRs(3)
------------

And the 'rec' TypeName() is 'Byte()'

But I can't get it to ADODB.Stream. How Can I do?
Or Can I read binary column to another way?


Pardon my poor English.
Thanks.


- GuyV -

 

[B_O_B]

I think ADODB stream requires a physical file. Something like the following
where errorImage is the file path.

Set objStream = Server.CreateObject("ADODB.Stream")
With objStream
.Type = adTypeBinary
.Open
.LoadFromFile errorImage
End With

x = objStream.Read

objStream.Close
Set objStream = Nothing