| View previous topic :: View next topic |
| Author |
Message |
Tony Guest
|
Posted: Mon Apr 09, 2007 7:10 am Post subject: Streaming video from SQL Server to Windows Media Player |
|
|
I have created a simple Delphi 7 app to catalog my home videos. I have
written this using SQL Server 2005 Express and I was toying with the
idea of storing the actual videos in a varbinary(max) field and then
playing them from within the app using Windows Media Player.
I have got the videos loading into a database field and I am able to
launch Media Player. I cannot figure out if it is possible to stream
the videos from the database field to Media Player. I have tried using
SaveToStream but this doesn't appear to work.
Is this possible? |
|
| Back to top |
|
 |
Doni Devito Guest
|
Posted: Tue Apr 10, 2007 8:11 am Post subject: Re: Streaming video from SQL Server to Windows Media Player |
|
|
hi tony,
Sure its possible. in my opinion there are 2 ways. First, in ms sql server
there are readtext and writetext functions. you can read from database with
chunks. But you had to write threads to read while running the wideo. The
other way is to write something like streaming server. kbmmw
(www.components4developers.com) has a file service. The file service can
send file to client with chunks and its multi threaded.
In my opinion, best way is inheriting the file service to read/write
database with readtext and writetext.
"Tony" <tony_onz (AT) yahoo (DOT) com> wrote in message news:4619a0a0$1 (AT) clear (DOT) net.nz...
| Quote: | I have created a simple Delphi 7 app to catalog my home videos. I have
written this using SQL Server 2005 Express and I was toying with the
idea of storing the actual videos in a varbinary(max) field and then
playing them from within the app using Windows Media Player.
I have got the videos loading into a database field and I am able to
launch Media Player. I cannot figure out if it is possible to stream
the videos from the database field to Media Player. I have tried using
SaveToStream but this doesn't appear to work.
Is this possible? |
|
|
| Back to top |
|
 |
Doni Devito Guest
|
Posted: Tue Apr 10, 2007 8:11 am Post subject: Re: Streaming video from SQL Server to Windows Media Player |
|
|
by the way,
dont forget that ms sql server express edition has a size limit.
good luck.
"Tony" <tony_onz (AT) yahoo (DOT) com> wrote in message news:4619a0a0$1 (AT) clear (DOT) net.nz...
| Quote: | I have created a simple Delphi 7 app to catalog my home videos. I have
written this using SQL Server 2005 Express and I was toying with the
idea of storing the actual videos in a varbinary(max) field and then
playing them from within the app using Windows Media Player.
I have got the videos loading into a database field and I am able to
launch Media Player. I cannot figure out if it is possible to stream
the videos from the database field to Media Player. I have tried using
SaveToStream but this doesn't appear to work.
Is this possible? |
|
|
| Back to top |
|
 |
|