Home All Groups Group Topic Archive Search About

Retrieve PDF Image in Sql Server

Author
7 Sep 2006 6:44 AM
S
We are storing PDF Images in a table in Database. I need to extract the
binary data and pass it on to the application code to export (PDF Image) to
another format (TIFF) to feed another system.

I have gone over this article listed below. Is there another way to extract
PDF binary data from the database into an xml stream and pass that (xml
stream) to the application code. If yes, can you give me pointers on how this
can be done? http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconobtainingblobvaluesfromdatabase.asp

Author
7 Sep 2006 10:16 AM
Robinson
Show quote
"S" <S@discussions.microsoft.com> wrote in message
news:FD106E21-5C83-45F4-9E87-151D23352842@microsoft.com...
> We are storing PDF Images in a table in Database. I need to extract the
> binary data and pass it on to the application code to export (PDF Image)
> to
> another format (TIFF) to feed another system.
>
> I have gone over this article listed below. Is there another way to
> extract
> PDF binary data from the database into an xml stream and pass that (xml
> stream) to the application code. If yes, can you give me pointers on how
> this
> can be done?
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconobtainingblobvaluesfromdatabase.asp

The above seems to be the best way, where you have an arbitrarily large blob
size.  In my application, I know blobs are between 40 and 120k, so I just
hold a single buffer and read the entire thing in one go, without looping.

AddThis Social Bookmark Button