how should i close conntions & recordset ??

[Hernán Castelo]

hello

I suspect i don't close well my recordset
how can i CLOSE / FREE / RELEASE
recordSets and connections
in order to avoid server memory loss???

thanks

--
atte,
Hernán Castelo
UTN - Buenos Aires
.. . . . . . . . . . . . . . . . . . . . . . . . . .
.. . . .

"Antes de poner caco-citas al final de los mensajes, pensemos un poco"
(de El chamán de Calidelphia,
opus póstuma de Kânr Djkmilÿa)

 

[Jeff Cochran]

I suspect i don't close well my recordset
how can i CLOSE / FREE / RELEASE
recordSets and connections
in order to avoid server memory loss???

rs.close
set rs = nothing

conn.close
set conn = nothing

Jeff