Database Connection Close Test

Is there an easy way to test if the database connection is being closed?

[webworker us]

Hi All.

I am currently working to revamp my intranet, and am having a bit of trouble with my databases closing. I am pretty sure its just me not getting all of them closed at the end, and I was wondering if there was an easy way to see which file wasn't closing its connection.

I am currently using Baby Web Server, but if anybody has any better free suggestions, I would happily accept. (I'm not an IIS fan becuase my permissions aren't working, yet another of my shortcomings)

Thanks

Casey

[mattglet]

What are you using as a database? Access, SQL Server?

[Easy_Coder]

if dbConnObject.adStateOpen = 1 then
'db connection is open
else
'db connection is not open
end if

[webworker us]

Access

[Easy_Coder]

My earlier code is foobar... should read:

if dbConnObject.State = adStateOpen then
'dbconnection is open
else
'db connection is not open
end if

[webworker us]

Ok Cool thanks. I will add it to the bottom of all my pages.

Casey