Number of database connections

[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.

 

[Zoury]

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.

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...

 

[Tull Clancey]

Unfortunately an Access 2000/XP database, I don't think this information is
available from the Jet engine.

Cheers,
Tull.

 

[Zoury]

Hi Tull !

see if this helps you
http://support.microsoft.com/default.aspx?id=285822

 

[Tull Clancey]

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.