<div>
Try closing the rs after your append then try closing the connection.
</div>


Try closing the rs after your append then try closing the connection.

<div>
I'll try the update method.
</div>


<div>
<div class="content wysiwyg-content">
I have a ado connection object(Cnn), I do an .appendchunk on the recordset(rs), and when I try to close the Cnn - I get an error saying I can't explicitly close the Cnn while it is in a transaction, but by that time I have already closed the rs and I'm doing appending.
</div>
</div>


I have a ado connection object(Cnn), I do an .appendchunk on the recordset(rs), and when I try to close the Cnn - I get an error saying I can't explicitly close the Cnn while it is in a transaction, but by that time I have already closed the rs and I'm doing appending.

ADO Cnn.Close error

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.