![]() |
![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
![]() |
| |
| | #1 (permalink) |
| | Re: Connect to DB Set oConn = Nothing? Please forgive my ignorance…. Why does one close the connection, and where/how should this be done? Thanks, Mark |
My System Specs![]() |
| | #2 (permalink) |
| | Re: Connect to DB Mark wrote: Quote: > Set oConn = Nothing? > Please forgive my ignorance…. Why does one close the connection, and > where/how should this be done? oConn.Close I believe the connection gets closed when the script ends, but I like to make sure. There is no need to set the object reference to Nothing. I know that if you fail to close files, they can remain open. I like to be safe with connection objects as well and make sure they get closed. The exact behavior may depend on the DBMS and driver used. -- Richard Mueller MVP Directory Services Hilltop Lab - http://www.rlmueller.net -- |
My System Specs![]() |
![]() |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| Can Connect to Router but unable to connect to internet | Vista networking & sharing | |||
| "Connect automatically" checkmark disappears from "Dial-up Connect | Vista installation & setup | |||
| "Connect automatically" checkmark disappears from "Dial-up Connect | Vista networking & sharing | |||
| Can't connect to the internet, 3rd BRAND NEW computer that work connect! HELP! | Network & Sharing | |||
| Re: Can't Connect to Juniper Network Connect 5.4.0 | Vista General | |||