I've put alittle something together so that I can change a value in the database. But where do I put the: rs.close set rs = nothing I've tried almost every line and as soon as I have the code there I get:
I hope someone can help me with this, or with some other way to close this connection. This is something I'll be doing on rare occasions so maybe it's not that much of a deal if I leave it open? ;)
You are closing the variable 'rs' and then setting it to nothing. But your connnection to the database is set in the 'rsKey' variable so you should be closing 'rsKey' instead. Basically change the code which shuts down the connection to
Well, I changed the wordings, but I still don't know where in the code to put the closing. Any hint? =) Exactly what happen if I don't have any closing? Will there be an open connection for the next 3000 years? ;)
I have just been reviewing the code you posted. Since you are updating the database you are not expecting to return any results from it except for whether it was successful or not. So you do not need to set it to a variable.
set rsKey = my_Conn.Execute (strSql)
All you need to do is remove the code in red and to answer your question... if you don't close a recordset IIS will close it for you. In saying that you should really make an effort to close all connections to the database as soon as you have finished dealing with them. Otherwise they will remain in the servers memory affecting performance on high traffic sites and your relying on a computer to clean-up after you - a bit unreliable sometimes
Topic Locked
Posted - 08 January 2005 : 06:23:03
