L
Lin Ma
Hello,
I have a general question. In my asp page, I have DB connection, Recordset,
and some variables like
dim name, conn, rs
set conn = Server.CreateObject("ADODB.Connection")
....
set rs= server.createObject("ADODB.Recordset")
name = rs("username")
I know I need to close the connection like
conn.close
set conn = nothing
Do I need to close the recordset and variables? What is the reason?
Thanks,
Lin
I have a general question. In my asp page, I have DB connection, Recordset,
and some variables like
dim name, conn, rs
set conn = Server.CreateObject("ADODB.Connection")
....
set rs= server.createObject("ADODB.Recordset")
name = rs("username")
I know I need to close the connection like
conn.close
set conn = nothing
Do I need to close the recordset and variables? What is the reason?
Thanks,
Lin