file does not begin with %PDF - BinaryWrite

[TrailBlazer]

Hi - Been struggling over this issue for a long while. We store PDF's
in our SQL Server database. And I do a BinaryWrite to display the PDF.
It works for me without issue, on FireFox, IE, and Opera! But we are
receiving feedback that some users are receiving the file does not
begin with %PDF message.

ExecString = "spwEcoTrackUser " & Session("EcoUserID") & ",'coupon',"
& ID
set dbConn = Server.CreateObject("ADODB.Command")
dbConn.ActiveConnection = conn
dbConn.CommandText = ExecString
dbConn.Execute

' writes out the PDF
Response.ContentType = rs("CouponContentType")
Response.BinaryWrite rs("CouponData")

I have seen several posts about this issue, but no true solution. Can
anyone help?

THANKS!!!!

[pinoykid]

Hello there!

I am also experiencing the same problem both browsers - msie and firefox generates this kind of error "file does not begin with %pdf" when I try to open a pdf file that was scripted in java because my system is WINXP SP2.

When i format my harddisk & then install back the WINXP PRO the error was resolved only in MSIE but not in FIREFOX. Now the question is, do I need to install earlier version of FIREFOX to resolve this problem, or did I miss something that my latest version of FIREFOX is in need of?

Any one out there who can help me pls. reply or email me at [e-mail]

Help me OBI WAN KENOBI, YOUR MY ONLY HELP! ;)

Pinoykid