Who's connected to database. 
Author Message
 Who's connected to database.

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



Mon, 29 Jul 2002 03:00:00 GMT  
 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



Mon, 29 Jul 2002 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Cant't connect to DataBase

2. Mystery: ADO connects to database but fields don't appear on some computers

3. Can't connect to Access2000 database

4. VB can't connect to a Foxpro database using MDAC under W2K

5. Crystal 1.0 database error when connecting to Access 1.1 database

6. MSMAIL 'Cannot Connect to Postoffice'

7. Graphic example - 'smart' connected graphic objects

8. Graphic example - 'smart' connected graphic objects

9. Multi database SQL OLE DB can't open database (20599)

10. database object doesn't exist in database main(13)

11. can't connect to ADODB

12. can't connect to SQL Server

 

 
Powered by phpBB® Forum Software