detect DB connection

I have some code where I am connecting to a SQL-7 DB. I want to be able to detect the open connection & pass the user into the site.

Whats the correct syntax for this?

objConnection.Open()
> detect connection here<

Thanks,
~Piz

Not sure what your asking here.. but to detect the state of the connection object, use .state

Code:

---

objConn.State

---

Possible values are:
adStateClosed
adStateOpen
adStateConnecting
adStateExecuting
adStateFetching