Hi I am building an application where I am reading prices from a SQL Server
7.0 database which contains realtime prices that change every second or even
more often. I want these prices to be up to date on client application built
with VB 6.0 using ADO connections but I do not want to refresh or resynch
the query every X seconds. What is the best way to carry such real time data
to client applications?

Thanks in advance.