April 28th, 2003, 02:21 PM
Join Date: May 2001
Location: Washington DC, USA
Time spent in forums: 26 m 7 sec
Reputation Power: 13
ASP datasource won't allow add / update?
' set up and open database connection
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "DSN=dsnname", "username", "password"
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open "pressrelease", objConn, adOpenDynamic
When I try to execute this code, I get this error:
ADODB.Recordset error '800a0cb3'
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
However, when I make the below call, it returns true:
Any idea what the problem might be? Thanks very much for helping this ASP newbie.
Last edited by cliffyman : April 28th, 2003 at 02:24 PM.