image located on web, url for image stored in database

Hi,

I have a website and i am uploading the gif image to the database. i have used varchar(500) as the datatype and i am saving the file in the webserver so the path to it c:\intepub\....a.gif

my upload table has the folliwing feilds

UploadId Int Identity, Description, FileName, DiskPath varchar(500), weblocation varchar(500). I have a main sproc for the report where i am doing a inner join with other table to get the path of the gif..

So my question is how can i get a picture to show up on the report. .

What kinda datatype the gif file should be stored in the database? If it is stored as a varchar how can i access it and what is best way to reference that particular.

any help will appreciated....

Regards

Karen

This should help:

http://technet.microsoft.com/en-us/library/ms156482.aspx

But I must ask, why do you want to store the image in your database? Why not just host it on a website?

|||Anyone know a way to do this? I want to create a report that will use a table from sql that has a url which points to an image. I want this image to show up in a table in my report. The end goal is to have a searchable report with parameters that supplies immages (from the web) based on search criteria.
|||

Greg,

I have stored the image as a gif file on my webserver, but i couldnt access it, but now i gave the url to it and then specified it as a external image and everything works fine.. i am storing the reference to the image.... in the database.

Thanks a lot.

Regards

Karen

|||If I understand this post, I am having simmilar difficulties. I want to have a table in sql that has verious links to images locaed on the web. I want to display these images in my report. I'm quite confused and pretty new to this so if you can treat me like I know nothing at all and show me step by step what you did I'd really appreciat it.
|||

I have merged the two threads as they are highly related.

|||

Mflancour,

I am uploading the image using a file upload control in the database. and i am storing the like a URL http://Ipaddress/Nameoftheapplication/anyfolders/andsubfoldersintheapplication/Filename.gif. This field is set up in a my database as varchar(500) so i will be storing the above information in that field.

Then, in reporting service .... get the field that u want to access in the particular dataset

From the tool box select image and follow the wizard and select Database and then select the dataset and the field

then select the image and in the properties change the source to external and preview it.

and it should work

hope this helps.

Karen

|||Nevermind figured it out based on your earlier posts
sql