Causes of errors for ASP and ADO Recordset objects

ado| Error | object

What happens if the following error occurs when we run an ASP program?

There is a problem with the page you are trying to access and cannot be displayed.

Try doing the following:

• Click the Refresh button, or try again later.
  
• Open the localhost home page, and then find the links that are relevant to the information you want.

HTTP Error 500.100-Internal server error-ASP error
Internet Information Services

Technical information (for support staff)

• Error type:
  ADODB. Recordset (0x800a0e7d)
  The connection cannot be used to perform this operation. It may have been closed or invalid in this context.
  /asp/wwwroot/chat/login.asp, line 30th.
  

• Browser type:
  mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; Tencenttraveler. NET CLR 1.1.4322)

• Web page:
  POST??? /asp/wwwroot/chat/login.asp

• POST Data:
  Name=asdf&submit=%bd%f8%c8%eb&pass=asdf

• Time:
  May 22, 2005, 06:33:08

• Detailed information:
  Microsoft Support

　Answer:

The connection cannot be used to perform this operation. It may have been closed or invalid in this context. Possible error:

1 Database Connection object adodb.connection settings are incorrect.
2, when using its director to connect the object has been closed by you, you should reopen.
3, although the connection object is open, the Recordset object is set incorrectly.