Printable View
Anyone tell me why i get this error
ADODB.Recordset error '800a0cb3'
Object or provider is not capable of performing requested operation.
with this
strProvider = "DSN=MLAdmin;"
'create connection
Set cn = CreateObject("ADODB.Connection")
cn.Open strProvider
strQuery = "SELECT * FROM CONTACT"
Set rst = CreateObject("ADODB.Recordset")
rst.Open strQuery, cn
rst.AddNew
FOR i = 1 to rst.Fields.Count -1
rst.Fields(i).Value = Request.Form(rst(i).Name)
NEXT
rst.update
Hi gsc1ugs
you need to open the recordset as dynamic or keyset using the following
rst.Open strQuery, cn,adOpenDynamic
or
rst.Open strQuery, cn,adOpenKeyset
if you leave it blank it defaults it adOpenStatic and that doesn't let you change records
Hope this helps
Ian
still get the error.
ADODB.Recordset error '800a0cb3'
Object or provider is not capable of performing requested operation.
/aspweb/MLAdmin.asp, line 82
line 82 is rst.addnew
Ok
if you goto this thread from this morning it should sort out our problem
Ian
Now i get
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/aspweb/MLAdmin.asp, line 81
Now i get
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/aspweb/MLAdmin.asp, line 81
whats the options type adCmdText for?
what does that mean?
adCmdText - Evaluates CommandText as a textual definition of a command or stored procedure call.
LANPBAKER HELP