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.
| Author |
Topic |
|
royv
Constraint Violating Yak Guru
455 Posts |
 Posted - 2001-12-19 : 10:26:59
|
| http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=9541In the above thread, about half-way down, byrmol talks about triggers being able to return result sets to the client. This would seem like and ideal solution for streaming data from SQL Server to the client. Has anyone tried this? I have to design a real-time streaming system, and half the data resides in SQL Server, but if I could use this option to stream data to the client, that would be so awesome. Comments?*************************Just trying to get things done |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2001-12-19 : 10:53:58
|
| What's being streamed (what are you streaming)? Audio or video or something else? I've never heard of this being done before (non-file streaming), sounds interesting! The only problem I see with this is that ADO would need to use an asynchronous cursor if it's querying data from SQL Server. I'm not sure if this would work, and I don't think ADO would be the way to get the data. I'm not up on streaming technology, but I know that www.asptoday.com had some articles on this a few months ago. They're a subscription site, and to be honest their rate is too high for the quality (lack thereof) they provide. |
 |
|
|
|
|
|
Streaming data from SQL Server