[thelist] RE: Inserting PDF from SQL Server into web page

[Miller, Bart]

Disregard this...our server had to be rebooted for reasons unrelated to this
and now the PDF displays properly.  Apparently the code is correct.


-----Original Message-----
>Subject: Inserting PDF from SQL Server into web page

>I am using the following code attempting to read PDF data from SQL Server
and write it out to a web page:


><% Response.ContentType = "application/pdf" %>
><!--#include virtual="ADO_connect.asp"-->
><%
>Response.Buffer = True
 
>Query = "SELECT pdf FROM table1 WHERE id =  " & chr(39) &
Request.QueryString ("pdf_id") & chr(39)
>Set RS=MyConn.Execute(Query)

>Response.BinaryWrite  RS("pdf")
>%>

>But all I get is a page full of garbage -- however it does appear to
contain data from the PDF file.  Any ASP gurus >want to take a stab at this?