
Write ADO Field containing binary data (files) to the file system
Julian,
It is not only working with Microsoft files. When you save binary info into
image/binary field, SQL Server does not know if it is from the Microsoft or
not. I am pretty sure problem somewhere inside your code. What are you
tyring to achieve? Could you post your code here?
--
Val Mazur
Microsoft MVP
Quote:
> Hi,
> I inherited a SQL Server database with file attachments (PDF, Zip,
> Word etc.) stored in an Image field. I want to write the file
> attachments out to a directory on the file system. I reviewed
> Microsoft's article Q258038:
> "HOWTO: Access and Modify SQL Server BLOB Data by Using the ADO Stream
> Object"
> but this only seemed to work with Microsoft files (e.g. Word, Excel,
> BMP). Others (e.g. PDF, Zip) indicated that "the application could
> not open the file because it is not a supported file type or it is
> corrupted". Does anyone have any other suggestions? Thanks in
> advance.
> Cheers,
> Julian