Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Database Image Folder

Author  Topic 

kevin24
Starting Member

13 Posts

Posted - 2011-12-27 : 23:04:09
Hi, I have a database which contains the "FilePath" for "Images".
The Database is used in a website.

Given the number of images (in access of 5,000) would it be better to have the image folder outside the website.

If this is the case what would be the correct "FilePath" in the Database.

I have tried putting the folder on the drive and thus the "FilePath" would be C:\Images\xyz.jpg. However, this does not work for the website.

I would appreciate any help. Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-28 : 00:35:15
you need to create virtual folder for website and use it instead i guess

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

Sachin.Nand

2937 Posts

Posted - 2011-12-28 : 00:38:20
What version of SQL Server are you using ?

PBUH

Go to Top of Page

kevin24
Starting Member

13 Posts

Posted - 2011-12-28 : 01:47:12
Hi, I am using SQL 2008
Go to Top of Page

kevin24
Starting Member

13 Posts

Posted - 2011-12-28 : 01:48:41
Hi, how do I create a virtual folder. Thanks
Go to Top of Page

Sachin.Nand

2937 Posts

Posted - 2011-12-28 : 14:20:09
Have a look at Filestream.It is a real nice feature.

PBUH

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-28 : 23:57:48
I have written a blog on it

http://visakhm.blogspot.com/2010/02/filestream-storage-in-sql-2008.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -