This is the error that i receive.
Error Type:
ADODB.Recordset (0x800A0CB3)
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
/project/pages/addnew.asp, line 11
The code is;
<html>
<head><title>Di splaying registered guest Table</title>
<%
Dim objconn,strconn ,objrs
set objconn = server.createob ject("ADODB.Con nection")
strconn="provid er=microsoft.je t.OLEDB.4.0; Data Source="& _
"c:\inetpub\www root\project\pa ges\Register.md b"
objconn.open strconn
set objrs= server.createob ject("ADODB.Rec ordset")
objrs.open "register", objconn, 3,1
objrs.addnew
objrs("ADMNO")= request.form("a dmno")
objrs("NAME")=r equest.form("na me")
objrs("DATE FO BIRTH")=request .form("dob")
objrs("ADDRESS" )=request.form( "add")
objrs("FEES")=r equest.form("fe es")
objrs.update
objrs.close
%>
</head>
<body>
<table border=1>
<%
objrs.open "register",objc onn
while not objrs.eof %>
<tr>
<td> <%=objrs("ADMNO ")%></td>
<td> <%=objrs("NAME" )%></td>
<td> <%=objrs("DAT E FO BIRTH")%></td>
<td> <%=objrs("ADDRE SS")%></td>
<td> <%=objrs("FEES" )%></td>
</tr>
<%
objrs.movenext
wend
objrs.close
objconn.close
set objrs=nothing
set objconn=nothing
%>
</table>
</body>
</html>
NOTE:Iam A Begginner in asp please help me.
Error Type:
ADODB.Recordset (0x800A0CB3)
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
/project/pages/addnew.asp, line 11
The code is;
<html>
<head><title>Di splaying registered guest Table</title>
<%
Dim objconn,strconn ,objrs
set objconn = server.createob ject("ADODB.Con nection")
strconn="provid er=microsoft.je t.OLEDB.4.0; Data Source="& _
"c:\inetpub\www root\project\pa ges\Register.md b"
objconn.open strconn
set objrs= server.createob ject("ADODB.Rec ordset")
objrs.open "register", objconn, 3,1
objrs.addnew
objrs("ADMNO")= request.form("a dmno")
objrs("NAME")=r equest.form("na me")
objrs("DATE FO BIRTH")=request .form("dob")
objrs("ADDRESS" )=request.form( "add")
objrs("FEES")=r equest.form("fe es")
objrs.update
objrs.close
%>
</head>
<body>
<table border=1>
<%
objrs.open "register",objc onn
while not objrs.eof %>
<tr>
<td> <%=objrs("ADMNO ")%></td>
<td> <%=objrs("NAME" )%></td>
<td> <%=objrs("DAT E FO BIRTH")%></td>
<td> <%=objrs("ADDRE SS")%></td>
<td> <%=objrs("FEES" )%></td>
</tr>
<%
objrs.movenext
wend
objrs.close
objconn.close
set objrs=nothing
set objconn=nothing
%>
</table>
</body>
</html>
NOTE:Iam A Begginner in asp please help me.
Comment