How can I store images in MS SQL 7.0 and display it using ASP.<BR>Thanks!!<BR>
...While SQL Server supports this, it is not very efficient at pulling the binary data out. Just store the image name in the database and reference it in your pages.
But this won't work if the directory where the image is, changed right?I may be wrong I don't know I am new to all this.<BR>Thanks
...You don't necessarily have to store the path as well. Whatever you opt to do, store attributes of the image such as filename and/or path in the database but don't store the actual binary file.<BR><BR>