Saving wav file as blob - need to stream

We are curently saving/backing up wav files in a sql table as a blob

How can I access that and play the file in whatever media player is the default?

Thanks
Larry Bristersr. DeveloperAsked:
Who is Participating?
 
Neil RussellConnect With a Mentor Technical Development LeadCommented:
Dont do it! Save the files to disk and just save a file location in the sql database. Its far far more eficient and time saving.
0
 
indianguru2Connect With a Mentor Commented:
Look at the FILESTREAM Option of SQL itself if you are using SQL Server 2008 R2

http://technet.microsoft.com/en-us/library/bb933993.aspx
0
 
Larry Bristersr. DeveloperAuthor Commented:
We're actually going to do both.
Saving into a blob as well as a folder with a filepath stored on the server table.
The wav file(s) will be cleaned out monthly
At that point if (ever) needed, can stream from blob.
Blobs removed every quater
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.