The following ASP code yields the following run-time error, I want to know
which approaches for adding records. Using "Insert Into" statement or AddNew
method in recordset object?? As I mentioned in previous post, when I use
"Insert Into" SQL statement, it yields "ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed."
<%
Dim objRS
Set objRS = Server.CreateObject ("ADODB.Recordset")
objRS.Open "test", strConnect, adOpenStatic, adLockOptimistic, adCmdTable
objRS.MoveLast
objRS.AddNew ' add a new record
objRS("id") = "9999"
objRS("name") = "Psycho"
objRS.Update
objRS.Close
Set objRS = Nothing
%>
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.