Operation is not allowed when the object is closed

[leonelvr]

this is just part of my code.....

on error resume next

DSN = sDsn
Set con_temp = Server.CreateObject("ADODB.Connection&quot
con_temp.Open DSN


SQL = "select municipiomatric, matricula, tipo from cuentacorreo " &_
"WHERE usuario =" & "'" & usuariorec & "'" & " and passwd =" & "'" & contrasenarec & "'"




set rstemp = con_temp.execute(SQL)




if err.number<>0 then
set objASPError=server.GetLastError()
response.write err.description &&quot;-&quot; & err.Number &&quot;-&quot; & err.source &&quot;-&quot; & err.helpfile &&quot;-&quot; & err.helpcontext
response.end
end if




****************************

and on the page shows me....

Operation is not allowed when the object is closed.-3704-ADODB.Connection-C:\WINDOWS\HELP\ADO270.CHM-1240653


but if i see on the db server, the query arrives with out
errors,

i'm lost, that may be a db server problem, or web server...?

do i have something wrong?

what should i try?

 

[Veep]

For starters try a native OLEDB connection string:

http://www.able-consulting.com/ADO_Conn.htm