This article solves the problem that operations are not allowed when the object is closed in ASP. Only by finding the root of the strange problem can we truly solve it. Here it is for your reference.
When performing database operations in ASP
Copy the code code as follows:rs.Open strsql,conn,1,3
while not rs.eof //When the object is closed, operations are not allowed.
After searching for a long time, I finally found the problem in strsql...
The reason is:
This strsql = exec *** uses a stored procedure, and the sentence print @sql is added at the end of this *** stored procedure, which causes this problem. Comment it out and it will be OK...