Click here to Skip to main content
15,913,027 members
Home / Discussions / System Admin
   

System Admin

 
GeneralRe: Yet Another Mystery in Win2K Server Pin
jhaga29-Apr-03 10:19
professionaljhaga29-Apr-03 10:19 
QuestionHow to get the process path by using API:"NtQuerySystemInformation" Pin
Artas_net24-Apr-03 0:26
Artas_net24-Apr-03 0:26 
GeneralNTOSKRNL Accesses the Internet Pin
Roger Wright23-Apr-03 19:28
professionalRoger Wright23-Apr-03 19:28 
GeneralRe: NTOSKRNL Accesses the Internet Pin
Bruce Duncan29-Apr-03 9:09
Bruce Duncan29-Apr-03 9:09 
GeneralRe: NTOSKRNL Accesses the Internet Pin
Roger Wright29-Apr-03 9:46
professionalRoger Wright29-Apr-03 9:46 
GeneralPerformance Monitor bug in XP Pin
imon_2nd23-Apr-03 13:45
imon_2nd23-Apr-03 13:45 
GeneralInternet Explorer plugins and user rights Pin
Richard O.18-Apr-03 8:50
Richard O.18-Apr-03 8:50 
GeneralApplication is still running or a crash occured Pin
ovidiu_pon17-Apr-03 22:08
ovidiu_pon17-Apr-03 22:08 
Hello,

Application
-----------
I've created a multi-tier application. Its architecture is:
On client machine --> the client application is an ActiveX EXE component (VBasic).
On server machine --> some COM+ server applications and a SQLServer database.


Use Case
--------
CLIENT1
--> asks SQLServer database for an object (= a row in objects table).
The state of this object is stored in a storage file.
--> if the object can be check out, it means nobody else have checked out the object,
the server will set the objects.checkedoutby = ClientID and will copy the stg file
in a shared folder on server machine.
CLIENT2
--> tries to check out the same object
--> the server must know (??? - MY QUESTION IS ABOUT THIS POINT) if the CLIENT1 application
is still running or a crash has occured and CLIENT1 was not able to check in the object.

Remarks
-------
1) CLIENT2 will receive a copy of the storage file if CLIENT1 is still running
2) CLIENT2 will have the possibility to restore the storage file from
an older version if a crash occured in the CLIENT1 application.
3) Many clients can log in using the same account (user name and password)
4) There can be more than one instances of the application on the same client machine

My solution
-----------
My solution is to create an instance of an "watchdog" ActiveX EXE on the client machine
when the client application is started. This "watchdog", from time to time (5 minutes by example),
will modify the value of a date field named NotificationDate in database.
When the client application shuts down, the "watchdog" will stop updating that field.
The stored procedure responsible for check out will use the value of NotificationDate field
to decide whether the CLIENT1 application that use this object is still running or a crash has occured.

Questions
---------
1) Is there a pattern for this problem?
2) What about my solution?

10x,
Ovidiu
QuestionHow to make a hint window in explorer? Pin
Zenitram17-Apr-03 10:28
Zenitram17-Apr-03 10:28 
AnswerRe: How to make a hint window in explorer? Pin
Stephane Rodriguez.17-Apr-03 11:00
Stephane Rodriguez.17-Apr-03 11:00 
GeneralRe: How to make a hint window in explorer? Pin
Zenitram18-Apr-03 8:21
Zenitram18-Apr-03 8:21 
GeneralRe: How to make a hint window in explorer? Pin
Stephane Rodriguez.18-Apr-03 8:32
Stephane Rodriguez.18-Apr-03 8:32 
AnswerRe: How to make a hint window in explorer? Pin
J. Dunlap18-Apr-03 9:27
J. Dunlap18-Apr-03 9:27 
GeneralRe: How to make a hint window in explorer? Pin
Zenitram18-Apr-03 9:51
Zenitram18-Apr-03 9:51 
AnswerRe: How to make a hint window in explorer? Pin
Vasudevan Deepak Kumar25-May-03 19:31
Vasudevan Deepak Kumar25-May-03 19:31 
GeneralCustom Gina on XP Home Pin
Dave Wilson15-Apr-03 13:13
Dave Wilson15-Apr-03 13:13 
Generaldebug user Pin
karanba14-Apr-03 7:36
karanba14-Apr-03 7:36 
GeneralRe: debug user Pin
vishal S.21-Apr-03 1:04
vishal S.21-Apr-03 1:04 
Generalsubst Pin
karanba14-Apr-03 7:29
karanba14-Apr-03 7:29 
GeneralWINS Server on Win2k Pin
John M. Drescher10-Apr-03 19:53
John M. Drescher10-Apr-03 19:53 
GeneralBrowser Service Curiosity Pin
Roger Wright9-Apr-03 4:06
professionalRoger Wright9-Apr-03 4:06 
GeneralNetwork throttler / simulator Pin
Arun Bhalla8-Apr-03 8:00
Arun Bhalla8-Apr-03 8:00 
GeneralBMP for boot Pin
karanba8-Apr-03 3:11
karanba8-Apr-03 3:11 
GeneralRe: BMP for boot Pin
Sarvesvara (BVKS) Dasa15-Apr-03 20:10
Sarvesvara (BVKS) Dasa15-Apr-03 20:10 
GeneralGetIpNetTable and MFC dialogs Pin
tom767-Apr-03 4:35
tom767-Apr-03 4:35 

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.