[thelist] Retrieving OLE File from Access DB with Classic ASP
Chris
evolt at cubeit.co.uk
Thu Dec 15 04:20:28 CST 2005
> 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 !
More information about the thelist
mailing list