Visualizing PDFs

[Jeff Boyce]

I've inherited a SQL-Server database which holds PDFs in an image field.
(don't ask, don't tell <g>)

So far what I've found suggests that I'll need to copy that image field to a
temp file on my PC before opening it in a separate window (i.e., using
hyperlink to open it).

I've been wrestling with the ReadBLOB and WriteBLOB code using GetChunk and
AppendChunk, but haven't found a way that lets me put a copy of the image
into the temp file. Every approach I've used returns a length of 0 for the
FieldSize of the field returned in the recordset.

I've confirmed that the recordset is not empty, and confirmed in Access that
the SQL returns an OLE Object.

Any leads?!

Thanks in advance

Jeff Boyce

 

[Jeff Boyce]

Yah!

For what ever use someone downstream can make of it, I ended up finding a
MUCH simpler approach to reading and writing PDF files from/to SQL-Server.
The ADODB.Stream object works wonders!

Check KBID = 258038

Jeff