closing open connections in the catch 1

[michelleHEC]

How can I close the open connection when the try/catch catches an error? I have tried cnName.close() but it doesn't recognize the cnName because it is out of the area it was created in. Once the error is caught and the program is tried again, I get the connections already open message... thank you in advance...
Michelle

 

[RiverGuy]

Declareit outside of the Try/Catch block.

 

[michelleHEC]

Thank you, sometimes I just look too close to things! I should have realized that...