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.
stream varbinary PDF file from SQL 2005 to browser using ASP
1k views Asked by Jeff Roller At
1
There are 1 answers
Related Questions in SQL
- SQL schema for a fill-in-the-blank exercise
- Hibernate: JOIN inheritance question - why the need for two left joins
- What's supposed to be the problem in this query?
- Compare fields in two tables
- How to change woocomerce or full wordpress currency with value from USD to AUD
- Dynamic query creation with Array like implementation
- SQL query to get student enrolled in this month in a course - Moodle
- SQL LAG() function returning 0 for every row despite available previous rows
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- how to use system's environnement variables in sql script
- PHP fetchAll on JOIN
- Multitable joining in Sql
- How to display name starting from 'z' by using BETWEEN cmd only?
Related Questions in PDF
- How to use custom font during html to pdf conversion?
- How to get content of BLOCK types LAYOUT_TITLE, LAYOUT_SECTION_HEADER and LAYOUT_xx in Textract
- PDF form checkbox/radio button ignores content stream
- Suggest python library for rendering html to pdf files
- Problems with the order in which PDF files are created
- Centering a map element on a generated PDF
- download all pdf files from website doesn't support wildcard
- How to enter external pdf into quarto book while keeping page layout+numbering
- How do I create a website that combines user input and standard text and converts it into a pdf?
- Excel VBA error 1004 on PDF export - not a path issue
- downloading pdf using requests not working
- Creating pdf on Firestore with Pdfplum: Template path "no such object"
- Export password protected PDF from QGIS
- XPS convert PDF with Ghostscript
- Download PDF in ASP.NET MVC application
Related Questions in ASP-CLASSIC
- How can I execute logic code on ASP Classic Server side by using Jquery ajax?
- Migrating an ASP application between services shows ODBC Driver error: data source name not found
- Varchar(max) causing other other accesses of the record set to return null
- ASP Classic / JS multi select filter
- Missing VBScript.Encrypt on Windows Server 2019
- How to identify a user's location
- ASP Fix/Int functions not behaving as expected
- ASP Classic 3rd Party DLL Registration
- How To Capture Form Data using OnChange
- Stream response in a file
- iis 8.5, how to set visitor permission only on current site?
- How do you replace the last comma with "and" in a comma-separated string?
- CRUD operation not work with ADODB and SQL server using MSOLEDBSQL19 Provider and "strict" option (TLS1.3)
- Using a specific User/Domain in a Msxml2.ServerXMLHTTP request in classic ASP
- JavaScript won't execute when calling webpage via VBScript using XMLHttpRequest
Related Questions in STREAM
- How to start a download and render a response without hitting disk?
- How to properly handle byte buffers from C to Ada?
- Color Thresholding JS, Average Image Color Detect JS
- FastAPI finish streaming function in StreamingResponse even if client closed the connection
- How can I connect to a websocket from a vue app that is exposed to the network (yarn dev --host)?
- PHP: How to get the Content-Length from stream request for chunk download
- How to handle errors inside a NodeJS stream?
- Python TCP Server that both sends and or receives data (independently) using asyncio streams?
- Efficient string replace in a stream
- Using polly to generate audio from LLM output
- Stream YAML output, rather than loading everything into memory
- Python: Creating Zip file from Minio objects results in duplicate entries for each file
- Node.js/Express File Download Returns 0-Byte Plaintext Files
- Stream data from server component in NextJS 14 App Router
- How to read from last position when logstream is interrputed
Related Questions in VARBINARY
- Retrieve VARBINARY from SQL Server table using FileStream to save file in VB.Net
- Preview a varbinary file stored in database on a new tab instead of downloading using ASP.NET MVC
- Set varbinary size in Entity Framework C#
- Incorrect insertion of data into the table
- Sync data between instances using binary data
- Correctly store and retrieve PDF file using SQL database with .NET
- Specific Effects of using nvarbinary vs nvarchar for storing images
- Error opening a Word doc file downloaded from a SQL SERVER Image field
- Reading VARBINARY via SQLAlchemy
- Upload PDF as binary data to SQL Server via NEXT.js app
- Varbinary search with min and max pattern type
- sql server varbinary data output to azure blob
- SQL Server Varbinary fields - identify the type of file thats in there
- SQL Editor Query Java Object saved into VARBINARY column
- Encoding and decoding with Microsoft SQL Server using Postman
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
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.