[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