[RESOLVED] Loading pic from DB (Error Multiple-Step OLE DB)

[space_monkey]

Hey,

I found a good example from Rhino Bull on how to load and extract a picture to/from a db. My problem seems to be occuring when i try to extract the picture from the db. I get the Multiple-Step OLE DB Error. I'm using SQL Server.

'get all chunks and write then to a temp file
        For block_num = 1 To num_blocks
            [color=#CC0000]bytes() = adoRST.Fields("CARD_PICT_IMAG").GetChunk(BLOCK_SIZE)[/color][color=#CC0000][/color]
            Put #file_num, , bytes()
        Next block_num

The red line is the one is the one that is bugging me.
Any help is appreciated.

Also i want to check and make sure that my loadPic is putting the data into the db field properly. How can i do that?

Thanks
Andy