detect DB connection

[Piz Bruin]

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

[monte96]

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

objConn.State

Possible values are:
adStateClosed
adStateOpen
adStateConnecting
adStateExecuting
adStateFetching