I have a file in a varbinary type column in my SQL Server 2005 database. My question is how can I use ASP to link to that file, so users on the website can download it?
There's a reason why blobs/binaries are not widely used in databases, and you've just hit it! The simple answer is you need to spool it to a disk file, then dynamically link to it
Thanks. Instead of using the binary to store the file in the database. I am storing the file in a folder on the server, then storing the link to it in the database. Much easier.
Yep, much better idea, and it'll help with your db maintenance too. The only time I can see why it might be good to keep blobs in a db is for a configuration management system, and even then at a push! Glad you're all sorted now :)
Topic Locked
Posted - 12 January 2008 : 19:53:52
