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)
 MP3

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-09-19 : 07:42:23
Robert writes "I am using SQL Server 2000, am a relative beginner with SQL

What I am planning to do is create my record collection using SQL server with a web front end using Dreamweaver and ASP. Is there a way that you can store mp3 in SQL Server so if a search is made at the front end the track can be played. If mp3 can be stored as a blob how is this be done. My tables have been setup, as soon as my mp3 is stored within the database I can begin programming the front end

Thankyou for your help and I look forward to hearing from you soon

Rob"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-09-19 : 07:55:19
Instead of storing the file in blob, store the physical path and use that to play the track

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -