How can i list ALL open connections

M

mark | r

is there any ASP script that will display a list of all open connections on
a shared host

im trying to determine if my previous problem with "system resource
exceeded" can be resolved by brute force?

Mark
www.iosilver.co.uk
 
B

Bob Barrows [MVP]

mark said:
is there any ASP script that will display a list of all open
connections on a shared host

im trying to determine if my previous problem with "system resource
exceeded" can be resolved by brute force?

None that I am aware of, especially since you are using Access. There are
tools to read the ldb file to see who is working in your database, but,
since all accesses from IIS will be via IUSR, this will be less than
helpful. The ldb only contains users, not connections. Remember, Access is a
file-based database, so the tools available are limited.

If you were using SQL Server, you could use sp_who or sp_who2 to create a
list of all open connections, identified by SPIDs

Bob Barrows
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,904
Latest member
HealthyVisionsCBDPrice

Latest Threads

Top