Downloading BLOBS from Database without 3rd party tools 1

[rdd2]

How do I let client to download file stored in access database as BLOB without use of 3rd party components?
I guess I use stream object to send it to client but how to convert blob to file, which LoadFromFile property will accept?

 

[LikeThisName]

Did you have any success?

I am looking to download a million+ blobs as files.

i don't care if i have to buy 3rd party tools though i'd prefer to write some process, any pointers or recomendations would be helpful thanks.

LikeThisName <- ?

 

[DreXor]

i havent actually tested it, but until i get a chance, here's something to give a swing at :

you can use blobs in a DB to house images, these can in turn be streamed into a page for display, this doesn't differ from a regular download, so if you take the blob, add your proper response.addheader ( for contenttype etc ) you should be able to convert the image display code to a download page from db.


DreX
aKa - Robert
if all else fails, light it on fire and do the happy dance!

 

[DreXor]

links of use :

http://support.microsoft.com/kb/q258038/

http://www.freevbcode.com/ShowCode.Asp?ID=893

http://support.persits.com/show.asp?code=PS01050249

http://www.codeproject.com/aspnet/ImageAuthentication.asp

http://www.programming-x.com/programming/binary-data.html

DreX
aKa - Robert
if all else fails, light it on fire and do the happy dance!

 

[LikeThisName]

thanks drex for your valuable replies, i went with aspupload.com. Great product for what I needed.
I highly recommend it.

I was able to in a few minutes download all the blobs into the proper directories and then upload them back up.

this was to transfer extranets, one platform to another.
could NOT be done from the back end solely.



LikeThisName <- ?