
Who's connected to database.
Hi Sam, an easy way to do this is to add a table to the database. When a
user logs into your software, the table gets updated with their user
information including a flag that states they are online. When they log
off, you update the table and turn off the flag. Anytime you want to see
who is online in your software, just run a query against that table and
check against the online/offline flag.
--
Sincerely,
Todd B - Agendum Software
Award winning freeware and commercial products for VB developers!
Quote:
> I was wondering if there is any way in VB that I can find out the current
> connection of the people on the database (SQL) server. Any
> help would be appreciated.
> Thanks in advance
> Sam Mikkalson