Hello,

Using ASP Script, I need to store images from my LOCAL PC to online sql server in blob format.

Please advice!!

NOTE:
The images are located on my LOCAL MECHINE.
Image have to be saved in database.


Thank you,
Zeeshan Ahmed
itHighway

__________________
Zeeshan Dar
itHighway
Get in Touch with People Texting your Website
Advanced Real Estate Listings Solution - FREE Hosting

;;;The images are located on my LOCAL MECHINE.
Why dont you upload them to the server and store just the path

;;;Image have to be saved in database
why do you say 'have to be saved'?

I have heard of people doing this but never understood why. Most store the path to the image.

To any one out there - dont they??



Wind is your friend
Matt

Hi Matt, thanks for you reply. Its my clients requiment. He needs it for security. I know there are other ways to secure files. But he wants it to be secure through db

The file being the image? Mate, im fairly sure it is not possible to secure an image that is rendered on a web page - doesnt matter where it sits.

;;;he wants it to be secure through db
Interesting. Does he understand directory level security?


Wind is your friend
Matt

Hi Matt - my client is now agreed to save images path in database. He's something difficult to understand.

Thanks for your time and help!

I am still curious. Who stores images inside the DB, why, what do you achieve. There are so many reason why I think its a bad idea, performance for a start. Does anybody have any experience based knowlege on this one? do you do it? whats your experiences?

Wind is your friend
Matt

Actually, I was working on a Mortgage application forms where they want high security for their customers data.
When a customer fills online application they scan that application and other documents and store those scaned images into database.


You are right that it effects the performance, but if connections and record set are used properly then it doesnot really effects the performance and results for end user. Plus Hosting Server should be able to handle the pressure as well.

There's a US Govt website (I forgot its name) which holds more then 1 billion images in Sql Server db. I browsed that website with my 56K modem and there was no perfomance problem.

Now, there is another way to save the files and images which is mostly used by websites selling scripts and images. ASPupload component provide a downloadable utility that hides the actual page of downloadable file and user never knows the actual path of file.

I dont believe database security is better than dir level security. Especially when think about it like this; the .bak file is stored in a dir somewhere anyhow.

When a file is rendered on a web page its in your cache and becomes available. Hiding a path isnt hard to do but as soon as you render the image it is gettable.

Performance - IMO, Why even run the risk of possible performance problems.

have a good day mate

Wind is your friend
Matt