DO i need to close this as well ?

[Fary4u]

Hi
Do i need to close the Connection as well?

<%
Connection = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE="a.mdb"
sSQL = "SELECT * FROM Products"
set rsProdInfo = Server.CreateObject("ADODB.RecordSet")
rsProdInfo.open sSQL, Connection,adOpenKeyset,adLockReadOnly

Program Running . . .

rsProdInfo.Close
set rsProdInfo = Nothing

' DO I NEED TO CLOSE THE CONNECTION ?
Connection.Cose
set Connection = Nothing
%>

Regards
Fary4u

[ilearneditonline]

<%
' DO I NEED TO CLOSE THE CONNECTION ?
Connection.Cose
set Connection = Nothing
%>

I always do, but then again everyone tells me I am anal about things like that. I like to be on the safe side, besides what can it hurt to ensure that you have cleaned up after yourself.

[jhardman]

I always do, but then again everyone tells me I am anal about things like that. I like to be on the safe side, besides what can it hurt to ensure that you have cleaned up after yourself.

ilearnedit is right, it is a good idea to do it, but asp scripts close all connections automatically at the end of the script, so it is not necessary.

Jared

[Fary4u]

That's why when i do this it's give me error

<%
Connection.Cose
set Connection = Nothing
%>

or without this program continue working . . .

?????

[ilearneditonline]

That's why when i do this it's give me error

<%
Connection.Cose
set Connection = Nothing
%>

or without this program continue working . . .

?????

It is Connection.Close not Connection.Cose.

Sorry, I read your initial code sample incorrectly. You are not using connection as ADODB.Connection so there is not any need to do a Connection.Close. You could still do set Connection = nothing just to clean up the string.