all groups > sql server programming > september 2006 >
You're in the

sql server programming

group:

Retrieve PDF Image in Sql Server


Retrieve PDF Image in Sql Server S
9/6/2006 11:44:03 PM
sql server programming:
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?
Re: Retrieve PDF Image in Sql Server Robinson
9/7/2006 12:00:00 AM

[quoted text, click to view]

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