stream varbinary PDF file from SQL 2005 to browser using ASP

Question

I have a commercial program that stores PDF files to SQL 2005. I would like to be able to search for (I have that part) and then display the PDF file in a browser. It's the 'display the PDF file' that I'm having trouble with. I am using HTTP/ASP and would prefer to continue that way. I don't know anything about ASP.NET, so that would not be helpful to me. Any help would be appreciated. Thanks.

Related post: stackoverflow.com/questions/1811686/…

Oded
– Oded

2011-03-02 21:22:48 +00:00
Commented Mar 2, 2011 at 21:22 — Oded
– Oded, Commented Mar 2, 2011 at 21:22

Community · Accepted Answer · 2017-05-23 12:04:11Z

1

The best option here is to implement a HttpHandler that fetches the binary data from your database and outputs it to the response stream. This is the most efficient method available in ASP.Net.

There are many questions about HttpHandlers on SO, so implementing one should be easy: https://stackoverflow.com/questions/tagged/httphandler

One thing you should be aware of is that you should set the correct content type so that the browser recognices the pdf document.

edited May 23, 2017 at 12:04

CommunityBot

11 silver badge

answered Mar 2, 2011 at 21:25

Rune Grimstad

36.5k10 gold badges66 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

stream varbinary PDF file from SQL 2005 to browser using ASP

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related