ASP / IIS Recordset not updatable

[Martin van Vliet]

Hello,

When I try to run the following code I get an error: "Recordset not
updatable". It is possible to show data from the same table on a webpage, so
the database name and the table nam must be correct. I 've tried several
other things, also leaving out the
adOpenDynamic, adlockOptimistic.
If I run this code as VBA in an Access database, it works without problems.

<%
const DB_NAME = "C:\ASP\eOrganizer.mdb"

Call Main

sub Main
dim cndb
dim rs

set cnDB = Server.createobject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.Recordset")

cnDB.Connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
DB_NAME
cnDB.Open

rs.Open "tblNotes", cnDB , adOpenDynamic, adlockOptimistic
rs("notName") = "Meeting 1-2-2004"
rs.update


end sub

%>

 

[Bob Barrows]

Hello,

When I try to run the following code I get an error: "Recordset not
updatable". It is possible to show data from the same table on a
webpage, so the database name and the table nam must be correct. I
've tried several other things, also leaving out the
adOpenDynamic, adlockOptimistic.
If I run this code as VBA in an Access database, it works without
problems.

<%
const DB_NAME = "C:\ASP\eOrganizer.mdb"

Call Main

sub Main
dim cndb
dim rs

set cnDB = Server.createobject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.Recordset")

cnDB.Connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" & DB_NAME
cnDB.Open

rs.Open "tblNotes", cnDB , adOpenDynamic, adlockOptimistic
rs("notName") = "Meeting 1-2-2004"
rs.update


end sub

%>

http://www.aspfaq.com/show.asp?id=2062 - updatable cursor
http://www.aspfaq.com/show.asp?id=2009 - 80004005 errors

HTH,
Bob Barrows