Problem Downloading PDF with HTTPWebRequesst

[GJK]

Hello,
I am trying to download a pdf file using HTTPWebRequest class and then
save the downloaded pdf to a SQL Server 2005 database image column and
then display the pdf on a web app.
When I try to display the PDF, Adobe reader comes up and shows an error
msg "an uncrecognized token aID was found".

Here is my code to download

Dim binByte As Byte()
ResponseStreamR dr = New StreamReader(th eResponse.GetRe sponseStream(),
New UnicodeEncoding )
Dim objMemoryStream As New MemoryStream(Ne w
UnicodeEncoding ().GetBytes(Res ponseStreamRdr. ReadToEnd()))
binByte = objMemoryStream .ToArray()
return binByte

Then I write store the binByte to an image datatype column in SQL
Server which works.

Then I try to display the pdf using the following code where I get the
error "an uncrecognized token aID was found".

byte[] bteContent = (byte[])dr["file_conte nt"];
Response.AddHea der("Content-Disposition","a ttachment;filen ame=" +
fileName);
Response.Output Stream.Write(bt eContent, 0, bteContent.Leng th);
Response.Flush( );
Response.End();

Any idea what is wrong with the code?

Note: One thing I noticed during debugging:
theResponse.con tentlength=2206 9 where as objMemoryStream .Length
=21890.
Does this has to do something with pdf corruption. Why is this
difference?

[tdavisjr]

Dont set the Content-Disposition header. Instead, set the
Response.Conten tType = "applicatio n/pdf"

Everything else looks ok.

[DKode]

i havent palyed with SQL 2005 yet, but just a shot in the dark, you
said you were storing the data in SQL as image datatype. I think you
should try binary datatype.

thats how it was in sql2k at least, not sure if the same still holds
true to sql2005

[Joerg Jooss]

Thus wrote GJK,

Hello,
I am trying to download a pdf file using HTTPWebRequest class and then
save the downloaded pdf to a SQL Server 2005 database image column and
then display the pdf on a web app.
When I try to display the PDF, Adobe reader comes up and shows an
error
msg "an uncrecognized token aID was found".
Here is my code to download

Dim binByte As Byte()
ResponseStreamR dr = New
StreamReader(th eResponse.GetRe sponseStream(),
New UnicodeEncoding )
Dim objMemoryStream As New MemoryStream(Ne w
UnicodeEncoding ().GetBytes(Res ponseStreamRdr. ReadToEnd()))
binByte = objMemoryStream .ToArray()
return binByte
This will likely destroy any PDF file. You're handling PDF as UTF-16 encoded
text, but it's just binary content. Discard the StreamReader and read directly
from the response stream.

Then I write store the binByte to an image datatype column in SQL
Server which works.

Then I try to display the pdf using the following code where I get the
error "an uncrecognized token aID was found".

byte[] bteContent = (byte[])dr["file_conte nt"];
Response.AddHea der("Content-Disposition","a ttachment;filen ame=" +
fileName);
I'm nitpicking, but use AppendHeader(). AddHeader() is an ASP legacy API.
Also, set the HTTP Content-Type header for PDF:

Response.Conten tType = "applicatio n/pdf";
Response.Output Stream.Write(bt eContent, 0, bteContent.Leng th);
Response.Flush( );
Response.End();
Any idea what is wrong with the code?
No, that looks fine.
Note: One thing I noticed during debugging:
theResponse.con tentlength=2206 9 where as objMemoryStream .Length
=21890.
Does this has to do something with pdf corruption. Why is this
difference?

See above. PDF isn't UTF-16 encoded text.

Cheers,
--
Joerg Jooss
ne********@joer gjooss.de

[GJK]

Thanks for all the replies. I changed the code as follows and it is
working fine.

Dim binByte As Byte()
Dim myBinaryReader As BinaryReader = New
BinaryReader(th eResponse.GetRe sponseStream)
binByte = myBinaryReader. ReadBytes(theRe sponse.ContentL ength)
myBinaryReader. Close()
return binByte