[thelist] close connection

Scott Dexter sgd at ti3.com
Mon Mar 12 11:07:39 CST 2001

What is/are the sql string you're using? Remember that unless there is a
recordset generated (that actually has rows; a recordset that has EOF and
BOF true is a closed recordset), you don't need to explicitly close it.
--What I do in that closeConnection() routine is usually throw On Error
Resume Next in there so I don't have to worry about it in cases where the
recordset isn't open....

work: http://www.ti3.com/
non: http://thinksafely.org/

> -----Original Message-----
> From: Andrew Martin [mailto:comitque at hotmail.com]
> I keep getting an error when I try to modify a record in my 
> database.  The
> update, delete, or add all work; the changes get made, 
> however, I still get
> this error:
> " ADODB.Recordset error '800a0e78' 
> The operation requested by the application is not allowed if 
> the object is
> closed. 
> /preload.asp, line 47 "

More information about the thelist mailing list