sql server 2000 rsObj.Close
Set rsObj.ActiveConnection = Nothing
Set rsObj = Nothing
cnObj.Close
Set cnObj = Nothing
Set rsObj.ActiveConnection = Nothing
Set rsObj = Nothing
cnObj.Close
Set cnObj = Nothing
Set cnObj = Nothing rsObj.Close
Set rsObj.ActiveConnection = Nothing
Set rsObj = Nothing
先关连接,再释放记录集
然后是到关闭连接和SET ObjConnectionX=nothing.
当然中间含有一些判断,如属性State,可以先判断是否处于Open,当处于Open,再调用Close方法。