How to push realtime data from SQL Server

[Richterman]

Hello,

I am looking for the best way to approach the following situation ... 1) how
to connect 2) what I will need to maintain "realtime" updated data on the the
web browser (client) side 3) and if Flash Media Server 2 or the Flash runtime
(Platform) would be required.

I have a SQL Server database that is updated every 5 seconds with new data and
I need to have this data reflected on a Flash webpage. For simplicity, lets
just say its a table that contains 50 records with 4 fields. When/if the data
changes in any of the fields it needs to show up "realtime" on the webpage.
All thoughts would be helpful ... but unfortunately it must be done in Flash
(don't ask) ... Thanks in advance! :confused;

[deanjr]

:beer; Having a webpage designed using FLASH 8 that can communicate with a SQL
Database would be something I am looking into also. I hope someone that really
knows what he is doing explains this to us. I would like to use this with a
catalog that would be updated when I update the SQL Data. Why use FLASH?
Reason I am using it is that one has control of their work. The typical HTML
and other programming that works with HTML seem to NOT have a standard making
your website work look really good in one browser but look like heck in another
and some browsers will just not work like you designed it.

[D_Hansen]

I haven't done it before, but i believe you could use the XMLSocket object to accomplish this.