I am getting this error when I try to process an asp page:

Connection is busy with results for another hstmt

The relevant code is this:

strSQL = "Exec ProcRemove @Email = '" & strEmail&"'"
Conn.Execute StrSQL
conn.Close
Set conn = Nothing

The line that is generating the error is:
Conn.Execute StrSQL

My connection string looks like:

sConnString =
"DSN=Newsletter;Trusted_Connection=yes;SERVER=SERV ER1;APP=Microsoft
Development Environment;DATABASE=Newsletter;Address=10.0.0.5,1 433"
Conn.Open sConnString
Set cmdTemp = Server.CreateObject("ADODB.Command")
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = Conn

I have updated MDAC to 2.9 SP2.

Any way I can avoid this error.

Thanks