Hi,
Is it possible to store media files (like windows .wmv) on SQL Server 2005
and stream it back to the client via media server (not just download it)?
Regards,
Manuel Alves 5 3239
Hello Manuel,
As I know, there are some way to save a binary file in SQL server: http://support.microsoft.com/kb/317043
How to read and write a file to and from a BLOB column by using chunking in
ADO.NET and Visual C# .NET
But I am not sure if there is way to connect media server to SQL database.
I suggest you may post this question in a media server newsgroup, for
example:
microsoft.publi c.windowsmedia. server
Regards,
Luke Zhang
Microsoft Online Community Support
=============== =============== =============== =====
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=============== =============== =============== =====
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
Hi,
Thank you. I'll try the correct newsgroup. By the way, I already use SQL
Server to store and retrieve small binary files (under 100Kb) using VB.NET
(winforms and ASP 2.0), and I was just wondering about streaming (much
larger files and streaming <> just retrieve).
Best regards,
Manuel Alves
"Luke Zhang [MSFT]" <lu******@onlin e.microsoft.com > wrote in message
news:OC******** ******@TK2MSFTN GXA01.phx.gbl.. . Hello Manuel,
As I know, there are some way to save a binary file in SQL server:
http://support.microsoft.com/kb/317043 How to read and write a file to and from a BLOB column by using chunking in ADO.NET and Visual C# .NET
But I am not sure if there is way to connect media server to SQL database. I suggest you may post this question in a media server newsgroup, for example:
microsoft.publi c.windowsmedia. server
Regards,
Luke Zhang Microsoft Online Community Support
=============== =============== =============== ===== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. =============== =============== =============== =====
(This posting is provided "AS IS", with no warranties, and confers no rights.)
As I know, SQL server can save a binary file less than 2 GB. But larger
file may cause slow performance when there are multiple requests.
Regards,
Luke Zhang
Microsoft Online Community Support
=============== =============== =============== =====
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=============== =============== =============== =====
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
Thanks,
Besides the fact that sql server won't be as good as the file system for
storing big files like this it lacks the capabilities of the media server.
I've got an answer from microsoft.publi c.windowsmedia. server. Thank you all
for your time.
--- from microsoft.publi c.windowsmedia. server: Hi, Is it possible to store media files (like windows .wmv) on SQL Server 2005 and stream it back to the client via media server (not just download it)?
Yes, you can do that I suppose. It's a lot of work though for no gain.
I already use SQL Server to store and retrieve small binary files (under 100Kb) using VB.NET (winforms and ASP 2.0), and I was just wondering about streaming (much larger files and streaming <> just retrieve).
In your scenario, you're using SQL server to store vast amounts of
data and hitting it really hard. Then you're getting WMS to transfer
the same data over the network. Probably you'd have to assemble some
sort of stream writer to mimic a WMS proxy
I can't see why you'd want to do all that work when you can simply use
SQL server to create the playlist dynamically (using the XML writer)
from a stored list of file locations on the server ?
Cheers - Neil
"Luke Zhang [MSFT]" <lu******@onlin e.microsoft.com > wrote in message
news:RQ******** *****@TK2MSFTNG XA01.phx.gbl... As I know, SQL server can save a binary file less than 2 GB. But larger file may cause slow performance when there are multiple requests.
Regards,
Luke Zhang Microsoft Online Community Support
=============== =============== =============== ===== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. =============== =============== =============== =====
(This posting is provided "AS IS", with no warranties, and confers no rights.)
He would probably want to use SQL Server 2005 to organize but not store
the media.
That is, have a table with
TITLE
YEAR
FILENAME
That points to the media which can be displayed on a web page.
When the user clicks on the hyperlink, it streams the media through
media server.
Manuel Alves wrote: Thanks, Besides the fact that sql server won't be as good as the file system for storing big files like this it lacks the capabilities of the media server. I've got an answer from microsoft.publi c.windowsmedia. server. Thank you all for your time. --- from microsoft.publi c.windowsmedia. server:
Hi, Is it possible to store media files (like windows .wmv) on SQL Server 2005 and stream it back to the client via media server (not just download it)?
Yes, you can do that I suppose. It's a lot of work though for no gain.
I already use SQL Server to store and retrieve small binary files (under 100Kb) using VB.NET (winforms and ASP 2.0), and I was just wondering about streaming (much larger files and streaming <> just retrieve).
In your scenario, you're using SQL server to store vast amounts of data and hitting it really hard. Then you're getting WMS to transfer the same data over the network. Probably you'd have to assemble some sort of stream writer to mimic a WMS proxy
I can't see why you'd want to do all that work when you can simply use SQL server to create the playlist dynamically (using the XML writer) from a stored list of file locations on the server ?
Cheers - Neil
"Luke Zhang [MSFT]" <lu******@onlin e.microsoft.com > wrote in message news:RQ******** *****@TK2MSFTNG XA01.phx.gbl...
As I know, SQL server can save a binary file less than 2 GB. But larger file may cause slow performance when there are multiple requests.
Regards,
Luke Zhang Microsoft Online Community Support
============= =============== =============== ======= When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ============= =============== =============== =======
(This posting is provided "AS IS", with no warranties, and confers no rights.) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Lonewolf |
last post by:
Hi everyone, pls forgive me for my lack of knowledge and skills if my
question sounds very stupid. I am trying to implement a video conferencing
software and I am currently looking at a few set of technologies, among them
WMP, RealMedia, H.323 and XviD (not sure if it is suitable for streaming
even) . I would like to seek the advice of those...
|
by: tom |
last post by:
I need a C#, peer-to-peer solution for streaming video from a webcam on one box to a client application on the other box. Can someone please help me with this? I can read video from a webcam easy enough but streaming the feed to a client application seems to be a different story
Any help would be appreciated
Thanks in advance
Tom
|
by: ashish |
last post by:
hi All,
I am trying to come up with an application which can protect media
files, and stream them to the user once the user is authenticated. I
want the application managed authentication.
I did some google on it, but could not find any specific examples, would
be great if anyone could provide a good starting point. The application
would...
|
by: poorna |
last post by:
hi all
i want to upload the video files to the server..
then i encode all the video files into flv files ...
and then i am go to streaming ...
in the mean while i create the thumbnail image from video..
doubts:
how to upload the video files to web server?
|
by: hzgt9b |
last post by:
Using VS 2003, VB.NET and/or ASP.NET 2.0,
BACKGROUND
I have a window forms based application that contains a TreeView control and
a WebBroswer (AxSHDocVw.AxWebBrowser) control. The TreeView is populated with
nodes that when clicked play an audio clip from specified local or web URL
and navigate the browser control to a specified local or...
| |
by: Amjad |
last post by:
Hi i am writing a application where i want to browse video file and copy data
into stream and send that stream over network...I have develop P2P windows
application where i successfully transfer text message to each other but now
i want to send video file and play that file on other end...I know the code
how to send the stream over the network...
|
by: Tony K |
last post by:
Is streaming audio capable in asp.net 2.0 / AJAX? What I mean by streaming
audio is: ability to play one or more songs back to back...or maybe even let
the user select several songs to play and it will play them back to back.
Thanks,
Tony K
|
by: donnyf |
last post by:
Hi guys. I've put together a website ( http://worldwidemediaproject.com
) that is a database of internet streaming tv/radio stations from
around the world. I have built the site with all users in mind. The
site should be Linux, Unix, Mac, Win, etc friendly as I do not hide
the actual stream link or force the user to use an embedded player to...
|
by: Bubbs |
last post by:
hi,
Lemme give u a little background on my problem. Ive created a client and server applications that receive and stream live time values. The client software is a clock that receives the time and displays it in a wpf app. Now when i use the DateTime.Now on the client app locally without using streaming the clock works great. However when I...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |