[thelist] Retrieving OLE File from Access DB with Classic ASP

[Chris]

Sorry, lack of explanation is because I hadn't written any code to try and
pull the PDF from the database as I don't know how.

I just had a play and the following code [left out the database connection
bits] will open the PDF in the browser [IE and Mozilla]:

Response.Buffer = True
Response.ContentType = oRs("fldFileType")
Response.BinaryWrite oRs("fldBinaryData")

I was looking for an option to force the browser to download the data.
There are plenty of examples of streaming a file from the filesystem but not
for lifting binary data from a database then streaming it to the browser.

I've tried using:

Dim objStream, myContents, myFileName

myFileName = "file.txt"

Response.ContentType = "application/octet-stream"
Response.AddHeader "content-disposition", "attachment; filename=" &
myFileName

Set objStream = Server.CreateObject("ADODB.Stream")

objStream.Open
myContents = oRs("fldBinaryData")

Response.BinaryWrite myContents

objStream.Close
Set objStream = Nothing

The ADODB Stream does not like being set to the database field and throws a
type mismatch error.  I suspect it will only work being fed a file from the
filesystem.

Thanks for the help so far.

> -----Original Message-----
> From: thelist-bounces at lists.evolt.org [mailto:thelist-
> bounces at lists.evolt.org] On Behalf Of Ian Anderson
> Sent: 19 December 2005 09:39
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] Retrieving OLE File from Access DB with Classic ASP
> 
> Chris wrote:
> 
> > I'd like to be able to provide options to open the PDF in a browser
> window
> > and to stream it to the client's browser as a 'save to' option.
> 
> You haven't said what actually happens in the browser when you try your
> code.
> 
> Does it fill the screen with garbage, or give an error message?
> 
> I'm wondering about setting content-type in the header, or something
> like that - the browser is expecting html or image data, but may be
> receiving the raw binary data from the PDF and trying to interpret it
> using its default settings.
> 
> More explanation of what is seen to be happening would surely help
> 
> Cheers
> 
> Ian
> 
> 
> --
> _________________________________________________
> zStudio - Web development and accessibility
> http://zStudio.co.uk
> 
> Snippetz.net BETA - Online code library
> File, manage and re-use your code snippets online
> http://snippetz.net
> 
> --
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !