Closing Connections

[James]

What's the proper syntax for determining if a connection is open before
closing it? Oddly enough, I can't find it on a google search.

 

[Stuart Palmer]

If you are doing things right you should never try and close a connection
before it's opened.

Ideally, I believe the best solution would be to open connection, throw
output values into variables and then immediatly close the connection.

Stu

 

[Bob Barrows [MVP]]

What's the proper syntax for determining if a connection is open
before closing it? Oddly enough, I can't find it on a google search.

Use its State property:
http://msdn.microsoft.com/library/en-us/ado270/htm/mdprostate.asp

Bob Barrows