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