sqlconnection open state

#1

how to check the connection state sql

if (oconn.State.tostring()="Closed")

or is there a more approiate way
thanks
MJ

#2

Quote:

or is there a more approiate way

How about:

if (oconn.State == ConnectionState.Closed)

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Mike J" <vettes_n_jets (AT) sbcglobal (DOT) net> wrote

Quote:

how to check the connection state sql

if (oconn.State.tostring()="Closed")

or is there a more approiate way
thanks
MJ

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

sqlconnection open state

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

sqlconnection open state - 04-13-2007 , 04:45 PM

Re: sqlconnection open state - 04-15-2007 , 07:28 AM