FSO Type Question

Results 1 to 2 of 2

Thread: FSO Type Question

  1. #1
    Join Date
    Dec 1969

    Default FSO Type Question

    Ok, here's what I need. I need to move an image that's located in a BLOB field in SQL Server and save it to a directory on the database. I've already poured through the FAQs and figured out how to grab the image. My question is how to save the image to a directory. Will the CreateTextFile method only write out text files? Never been asked to do this before, so it's all new to me! Thanks!

  2. #2
    Join Date
    Dec 1969

    Default Not with FSO...

    FSO only allows writing text.<BR><BR>But *MAYBE* with ADODB.Stream ???<BR><BR>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthwrite.asp<BR><BR>It would *appear* that if you can get your blob from the DB as an array of bytes (which I *think* you can), then you could write it to an ADODB.Stream.<BR><BR>And then you can save the stream to a file.<BR><BR>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthsavetofile.asp?frame=true<BR><BR>I have *NEVER* done this. Good luck!<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts