Uploading images to SQL Server

[webboy1]

Hi,

Can anyone recommend a good site for me to look at which will teach my how to upload images to SQL Server?

Most sites i have found so far require ASP.NET. I currently do not use this software.

I use standard ASP.

Any help appreciated!

Webboy

[RainMaker]

How do you want to upload them? do you want to do it by directory path or do you want to store RAW data?

[webboy1]

Erm.....not sure really. I have never done it before, so not sure exactly what is involved with it.

I have been looking into it and im slowly beggining to understand.......slowly.

So in answer to your question, im not sure exactly.

Which do you recommend?

[le_gber]

Not sure I understood. Anybody to correct me if I'm wrong!

I thought SQL Server was like an engine to translate code and where you could store a database. I didn't know you could store actual images as well.

If what you are trying to do is upload images using a form and then retreive this image in an asp page I think you can use PHP to upload (tutorial here: [developerfusion.com...] and then use your database to store the path to your image trhough an asp form.

I usually use a form to populate a db, so the only thing I do is to write the image name next to the other data relating to this particular database entry and retreive it on the display page.

Hope this helped

Leo

[RainMaker]

Good stuff leo, Generally I store the path to where the image is. If you are doing any uploading save it to somewhere being a /dir/dir and then store it in the Database respectively path wise. Storing RAW bits can get confusing and there is more potential of loss of data.

[le_gber]

Generally I store the path to where the image is. If you are doing any uploading save it to somewhere being a /dir/dir and then store it in the Database respectively path wise

when I do something like that for my not so computer literate customers, I usually manually type the image path on the diplay page and dynamically the image name.
They only have to enter the name of the pic they uploaded (save them a lot of thinking and me a lot of hassle from my customer who have problem retrieving the path ;) )

Leo

[docpowell]

You can store images as binary data (much more complicated, and takes up more server space). You can also simply upload an image to your site and add a link to the database which includes basically anything you want, ie, path, details, size, etc.

If you are looking for a good ASP solution, I suggest SoftArtisans FileUp. My hosting company offers it as a free component.

[RainMaker]

The component is really free? What is the Catch?

[sharbel]

No catch, SoftArtisans has a few free components. I use their PoP3 component for .NET , and its simply awesome, especially for free.

With regards to storing images in SQL Server. I will echo the sentiments of the others, its much better to just store the URL to the image in your DB and retrieve it and bind it to your image dynamically.

[docpowell]

Let me clarify something please:

I'm not sure if the SoftArtisans FileUp is free. It is just that one of the companys that host a website of mine, offers it as a free-to-their-customers component.