[thelist] close connection

Andrew Martin comitque at hotmail.com
Fri Mar 9 16:47:28 CST 2001


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 "

And here are the functions:
Function openConnection ()
	Set objDBConn = Server.CreateObject("ADODB.Connection")
	strConn = "[connection string]"
	objDBConn.Open strConn
	Set rsShow = Server.CreateObject("ADODB.Recordset")
	rsShow.ActiveConnection = objDBConn
End Function

Function closeConnection ()
	rsShow.close
	Set rsShow = Nothing
	objDBConn.Close
	Set objDBConn = Nothing
End Function







More information about the thelist mailing list