Multi User Program

[Vic88]

I am creating a multi user database with Vb. The database will be located on a server while the front end will be&nbsp;&nbsp;located on each clients computer. I want to implement a system whereby if a client is accidentally disconnected from the database,by removing the ethernet cable or the computer hangs up, his username and password are automatically removed from the list of active users.<br><br><br>Any suggestion will be highly appreciated.<br><br><br>Vic88

 

[Karl Blessing]

um, you would occasionally &quot;ping&quot; his connection on an interval and see if he's still there, in essence you apply a timeout. <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href=

http://kb244.8m.com>

</a><br>Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)<br>

http://www.brainbench.com/transcript.jsp?pid=629151

 

[jg1007]

If you are using RDS to implement your application, I believe there is a timeout method you can use, alhtough I have never used it.&nbsp;&nbsp;You can probably learn how to use it though MSDN.

 

[nikhilmehrotra]

try using a connection object and trap querytimeout and the error handler.<br><br><br>Nikhil

 

[MikeLacey]

Kb244's method is the most reliable I would think and it would let you know immediately if the client PC was down - but it's not easy to write that kind of code...<br><br>To monitor whether the client was still connected to the database - rather than just if the client was still running - you will need something listening in your client app - so that it can respond. The MS Winsock control will do that fairly easily. <p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>