CFF KB - Carrz-Fox-Fire Promotions Knowledge Base

CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.

Knowledge Base

Breadrumbs:
>>Development (Web and Desktop) >> Web Development >> ASP (Active Server Pages)
ADODB.Command error '800a0e7d' The connection cannot be used to perform this operation

Share With Friends ^{(Updated 6-8-2010)}

Article ID:
106
Date Created
Tuesday, February 22, 2011
This Article Has been Viewed
4133 times
Short Desc
Making sure that your connection string is not closed until the end of the page will prevent you from receiving the following error 800a0e7d.
Details
If you have closed your database connection and it is still needed, you will receive the following error.

ADODB.Command error '800a0e7d'
The connection cannot be used to perform this operation. It is either closed or invalid in this context.
/Profile.asp, line 22
Recreate Issue
To recreate this issue:
Close your connection to your database prior to trying to creating a new RecordSet.
Resolve Issue
To correct this issue.
Make sure that your Database connection is closed at the last line of your page.
This is can be done easily with a footer.asp page.
Placing your
<%
connection.close
set connection=Nothing
%>

At the bottom of the footer.asp page and placing this file at the end of your page
Via: 
This will stop these types of issues from happening in the future.

All Topics