Click here to Skip to main content
15,908,455 members
Home / Discussions / Database
   

Database

 
GeneralRe: Kill Sleeping Database Connections in SQL Server Pin
Altafqau16-Oct-03 23:49
Altafqau16-Oct-03 23:49 
GeneralADO and Pro-C Pin
WoonLeng13-Oct-03 19:56
WoonLeng13-Oct-03 19:56 
QuestionUpload File into SQL Server? Pin
DudleyDoorite13-Oct-03 4:34
DudleyDoorite13-Oct-03 4:34 
GeneralDataRow/DataGrid filter question. Pin
TravisMerkel12-Oct-03 13:06
TravisMerkel12-Oct-03 13:06 
GeneralRe: DataRow/DataGrid filter question. Pin
Armen Dalaliants16-Oct-03 4:02
Armen Dalaliants16-Oct-03 4:02 
GeneralSQL syncing Pin
Judah Gabriel Himango10-Oct-03 6:10
sponsorJudah Gabriel Himango10-Oct-03 6:10 
GeneralRe: SQL syncing Pin
Rob Graham10-Oct-03 12:32
Rob Graham10-Oct-03 12:32 
GeneralSQL syncing Pin
Guillermo Rivero13-Oct-03 3:34
Guillermo Rivero13-Oct-03 3:34 
The solution I found to this was to build a server component to which all clients get connected via remoting.

When a client do some updates to the database, it notifies the server component and the server component sends a message to each connected client notifying the update type.

This is done using remoting events.

http://www.codeproject.com/csharp/DotNetRemotingBasicTutor.asp[^]
http://www.codeproject.com/csharp/persistentevents.asp[^]


Free your mind...
GeneralIdentity Pin
Anonymous9-Oct-03 8:22
Anonymous9-Oct-03 8:22 
GeneralRe: Identity Pin
Mike Dimmick9-Oct-03 23:07
Mike Dimmick9-Oct-03 23:07 
QuestionWay to monitor SQL Server programatically? Pin
darrinps8-Oct-03 6:19
darrinps8-Oct-03 6:19 
AnswerRe: Way to monitor SQL Server programatically? Pin
Blake Coverett8-Oct-03 15:40
Blake Coverett8-Oct-03 15:40 
GeneralRe: Way to monitor SQL Server programatically? Pin
darrinps9-Oct-03 2:37
darrinps9-Oct-03 2:37 
GeneralCDaoWorkspace Pin
OTVAC3058-Oct-03 0:26
OTVAC3058-Oct-03 0:26 
GeneralRe: CDaoWorkspace Pin
Hans-Georg Ulrich13-Oct-03 2:14
Hans-Georg Ulrich13-Oct-03 2:14 
GeneralRe: CDaoWorkspace Pin
OTVAC30513-Oct-03 2:22
OTVAC30513-Oct-03 2:22 
GeneralDatabase Connections in Sleeping State in SQL Pin
Anonymous7-Oct-03 1:32
Anonymous7-Oct-03 1:32 
GeneralRe: Database Connections in Sleeping State in SQL Pin
Mike Dimmick7-Oct-03 22:44
Mike Dimmick7-Oct-03 22:44 
GeneralRe: Database Connections in Sleeping State in SQL Pin
Anonymous8-Oct-03 23:55
Anonymous8-Oct-03 23:55 
GeneralGeneral Network Error Pin
yyf6-Oct-03 7:54
yyf6-Oct-03 7:54 
GeneralRe: General Network Error Pin
Mike Ellison6-Oct-03 17:46
Mike Ellison6-Oct-03 17:46 
GeneralRDBMS Pin
buggy846-Oct-03 4:11
buggy846-Oct-03 4:11 
GeneralRe: RDBMS Pin
Mike Dimmick6-Oct-03 4:26
Mike Dimmick6-Oct-03 4:26 
GeneralSQL/C# Pin
Harry20005-Oct-03 12:09
Harry20005-Oct-03 12:09 
GeneralRe: SQL/C# Pin
Mike Dimmick6-Oct-03 4:33
Mike Dimmick6-Oct-03 4:33 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.