Synchronization between DB server and client. Possible?

[FU.U.NA]

Hi.

I'm using Windows XP, MSDE, VS.NET 2003.
I'm finding a way to synchronize data with DB server and client.
The 'synchronization' means:

"The client application notified from server about any changes on DB table."

Exactly, notifying mechanism from MS SQL server to ADO.NET client.
Any possible method exists?


PS.
Server and client are on same computer.
DB server is used for only strong data relationship management.
No any other purpose.

 

[DalePres]

There could be easier ways but here's what comes to my mind. You could use
a Web Service to do it. Call the web service asynchronously (i.e. in its
own thread) and let the service wait for a signal from MSDE. Create an
extended stored procedure that can be called from a trigger.

The process then becomes,

1. Table is updated
2. Trigger is called
3. Trigger calls extended stored procedure
4. Extended stored procedure calls web service
5. Web service signals waiting thread in your client app.

I am waiting to see what else others come up with. Maybe we'll both learn
something.

Dale

 

[Guest]

Hi

I'm searching for something that can notice a change in the DB, so pretty the same problem as you discussed here. I'm writing an ASP.Net application and I'm using a Firebird Db. Until now I haven't reasoned much about it, but maybe some of you has some knowledge about it or a hint

Thank
Big Joe