Sql server is the backend for the website. Can images be stored in the
Database for retrieval.
Thank you
Thank you
--
Bob Pfeiff
MCSD, MVP
Spectrum Technology Group, Inc.
Yes, but the access methods a kludgy. You're usually far better off
storing the UNC path to the image and storing the image on the
filesystem.
Neil Pike MVP/MCSE
Protech Computing Ltd
Yes, you can use IMAGE fields to hold your data.Quote:> Sql server is the backend for the website. Can images be stored in the
> Database for retrieval.
Best regards,
--
Gianluca Hotz __
Technical Service Manager at Alphasys srl / \/ /
MCP Windows & MCP + MVP SQL Server / /\/ /
Currently working for Ekar spa \ \/ /\
http://ghotz.home.ml.org \__/\ \
1. store image, or image path in DB?
Anyone with experience & opinion about whether there is any significant
advantage to storing image data directly in SQL Server instead of
storing just the *path* to image file?
The number of image files is small (hundreds, possibly), and the size of
each file is likely to be small (<50K).
Application is e-commerce, with the need to display item-images, prices,
etc. which match user's specifications.
Any experience & opinions would be appreciated.
Paul
2. DTS with stored procedures / error trapping
3. Image datatype, and storing images in SQL server
5. Storing images or pointers to images - advice please
6. Updating Database View using ADO
7. Storing Image into a Database image field
8. Urg: How easy to import data into SQL Server 7.0 from Access
9. Store image by using image datatype in SQL 7.0
10. Storing Images in Blobs versus Storing in Filesystem - Performance Issues
11. How to store images through stored procedures in SQL Server
12. Suggestions for storing images in SQL Server vs storing references to physical paths
13. Storing image as BLOB or only storing URL to fileshare