Hi, I am not an MS professional, but as I understand it, Smooth Streaming is a client/server protocol. The client is Silverlight, the (prefered) server is IIS Media.
Using SQL is out of scope for IIS Media, you will need another server solution. The IIS Smooth Streaming Transport Protocol is a published protocol, you can find out more about it here:
If you are highly motivated, you could create your own server to bridge between SQL and the client side. An equivalent of the pushencoder, or an implementation of the Smooth Streaming Format SDK (it would pick up the SQL stream and push it to IIS Media).
You might also be able to piece something together with VLC and Wowza.
Hi , Sorry for the delay from the Microsoft side, but I wanted to confirm that Nick is correct with respect to not supporting any direct connection to a SQL data source. At this time the only supported source is the file system.
Thank you for your reply. Since I guess MS has strategy implement it with SQL Server File Stream. MS said file stream in SQL server can solve performance read and write to store photo and video into database. Why MS implement file stream in SQL server? I guess
many many service in Web need to store photo and video into a storage. Common solution is store photo and video into file system and play it, so MS create file stream will solve it. But if photo and video store in database how to play it (without draw data
from database and save as file). I guess smooth streaming will solve it but it doesn't work with SQL file stream. I'm disappointed MS doesn't implement both with a solution. So I need to give up SQL file stream for my solution.
Sir, the problem I'm currently facing is "if photo and video are stored in database how to play it (without draw data from database and save as file)". Currently I don't know any other method other than SQL Server FileStream to store video in a database.
I'd be very much delighted if you reply to this post with any other possible method to stream video from a DB without saving it as a file. Thanks in advance.
eagle_tsui
3 Posts
How to get the streaming file from SQL Server and send it the client and play a video?
Mar 31, 2010 02:38 PM|LINK
eagle_tsui
3 Posts
Re: How to get the streaming file from SQL Server and send it the client and play a video?
Apr 01, 2010 04:49 PM|LINK
Nicolas.Drou...
43 Posts
Re: How to get the streaming file from SQL Server and send it the client and play a video?
Apr 07, 2010 05:22 AM|LINK
Hi, I am not an MS professional, but as I understand it, Smooth Streaming is a client/server protocol. The client is Silverlight, the (prefered) server is IIS Media.
Using SQL is out of scope for IIS Media, you will need another server solution. The IIS Smooth Streaming Transport Protocol is a published protocol, you can find out more about it here:
http://www.iis.net/community/files/media/smoothspecs/[MS-SMTH].pdf
If you are highly motivated, you could create your own server to bridge between SQL and the client side. An equivalent of the pushencoder, or an implementation of the Smooth Streaming Format SDK (it would pick up the SQL stream and push it to IIS Media).
You might also be able to piece something together with VLC and Wowza.
Best of luck,
-Nick
richma
1091 Posts
Microsoft
Re: How to get the streaming file from SQL Server and send it the client and play a video?
Apr 07, 2010 07:59 PM|LINK
Hi , Sorry for the delay from the Microsoft side, but I wanted to confirm that Nick is correct with respect to not supporting any direct connection to a SQL data source. At this time the only supported source is the file system.
Richard
eagle_tsui
3 Posts
Re: How to get the streaming file from SQL Server and send it the client and play a video?
Apr 11, 2010 10:33 AM|LINK
Smooth Streaming Media Services
nnmanobala
1 Post
Re: How to get the streaming file from SQL Server and play it locally
May 03, 2011 11:20 AM|LINK
Sir, the problem I'm currently facing is "if photo and video are stored in database how to play it (without draw data from database and save as file)". Currently I don't know any other method other than SQL Server FileStream to store video in a database. I'd be very much delighted if you reply to this post with any other possible method to stream video from a DB without saving it as a file. Thanks in advance.