Number of database connections

  • Thread starter Thread starter Tull Clancey
  • Start date Start date
T

Tull Clancey

Can anyone help me here? VB Net Application with an Access Database
connection (OLEDB), I need (in code) to be able to retrieve the number of
active connections on the database, maybe from more than one PC.

Anyone any ideas?

Cheers,
Tull.
 
Hi Tull ! :O)
I need (in code) to be able to retrieve the number of
active connections on the database, maybe from more than one PC.
Click to expand...

What DB are you working with ? Most DBs (like SQL Server and ORACLE to name
a few) offers procedures or views that provides you this kind information...
 
Unfortunately an Access 2000/XP database, I don't think this information is
available from the Jet engine.

Cheers,
Tull.
 
Thanks, but I'm not sure this is what I need.

Basically I need to ensure that all OLEDB Connections to the database are
closed correctly, so it's the number of the OLEDB Connection class running
that I need to return, I think!

Cheers,
Tull.
 
Back
Top