How to store PDFs and photos in the database?

Is it easy to store and retrieve photos and PDFs in SQL Server 2000?
My boss thinks it should be drag and drop but I can't find anything on it.
Is there any programming involved or is it transparent to the user? We wo
uld like to store PDFs and JPGs in SQL then link to them with JSP (we don't
do asp) displaying the resu
lt in a web browser.
Are there any white papers on the subject?
Thanks,
Randy K
wawork@.hotmail.comSQL Server is not Access, and nothing is drag 'n' drop. You will have to do
some programming if you want to do it.
Here is some general info on whether it's a good idea to store images in a
SQL Server database at all:
http://www.aspfaq.com/show.asp?id=2149
As for how to do it, that depends on your client... Search the archives of
this group as well as Google and you'll find lots of examples in different
languages.
"Randy K" <anonymous@.discussions.microsoft.com> wrote in message
news:CBEB9065-12D3-4488-9D11-E01D89B55C2B@.microsoft.com...
> Is it easy to store and retrieve photos and PDFs in SQL Server 2000?
> My boss thinks it should be drag and drop but I can't find anything on it.
Is there any programming involved or is it transparent to the user? We
would like to store PDFs and JPGs in SQL then link to them with JSP (we
don't do asp) displaying the result in a web browser.
> Are there any white papers on the subject?
> Thanks,
> Randy K
> wawork@.hotmail.com
>|||This posting is provided "AS IS" with no warranties, and confers no rights
Hi ,
I found the following link which talks abt something similar , however it
uses oracle as a backend :
2 Program Examples Using Multimedia JSP Tags:
http://otn.oracle.com/products/inte...ml/jsptaglib_ex
amp.htm
hope it helps.
Regards,
Venkat.|||This posting is provided "AS IS" with no warranties, and confers no rights
Hi ,
I also found the following link which talks abt the same . It s forum
which discuss the same topic . Hope it helps ..!!
Topic: how to display images in jsp :
http://forum.java.sun.com/thread.js...message=2467239
Regards,
Venkat.