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

[Chris Dempsey]

Nobody able to help?  I re-wrote the script to use the filesystem as we had
to meet deadline but I'd still be interested if someone can advise how to
retrieve a PDF or other file [other than an image] from a Database.

Thanks,

Chris.

> -----Original Message-----
> From: thelist-bounces at lists.evolt.org [mailto:thelist-
> bounces at lists.evolt.org] On Behalf Of Chris
> Sent: 15 December 2005 10:20
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] Retrieving OLE File from Access DB with Classic ASP
> 
> > Why are you storing the file in the database?
> I knew someone would ask and I have my excuse ready.  I chose to store
> both
> the PDF and image in the database for ease of backup - simply download the
> database.
> 
> Security is not the issue as the files are all freely available to
> download
> from the site.  The site will hold a maximum of 70x 250kb PDFs at any one
> time and will be low traffic - maybe 100 visitors per day max.
> 
> Technically I know it's not the best solution but I think it should be
> fine
> for this site.
> 
> Can anyone advise how I would stream the file back out of the database?
> 
> Thanks.
> 
> 
> > Chris Dempsey wrote:
> >
> > > I have written code to take a PDF file and insert it into an Access
> > > Database field via a form and file upload script.  Unfortunately I'm
> > > struggling to get it back out.
> >
> > Why are you storing the file in the database? Your Access file is going
> > to end up the size of a cow.
> >
> > Why not upload the file to a folder, and store only the filename in the
> > DB?
> >
> > If the concern is unauthorised downloading of the file, it should be
> > possible to upload the file to a folder outside of the web root, and
> > provide an ASP-based means to download it for an authenticated user.
> >
> > I haven't done this, but believe it to be possible - can anyone confirm?
> > I'm going to be building something similar soon.
> >
> > 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 !
> 
> --
> 
> * * 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 !