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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 How I Can Store Sound files in SQL Server2000

Author  Topic 

rammohan
Posting Yak Master

212 Posts

Posted - 2007-03-24 : 03:43:54
hi,
for my application, i need to store sound files in the sql server2000 database. so can u suggest me way to store n retrieve from database.

One can never consent to creep,when one feels an impulse to soar
RAMMOHAN

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-03-24 : 04:44:43
an easy way is to store just the path in sql server, and leave the file on the file system.

only problem with that is if you care about keeping the db in sync with the file system, it can be a pain. like if you delete a row from your table, should it delete the file too? it depends on the app.


www.elsasoft.org
Go to Top of Page
   

- Advertisement -