error

[gsc1ugs]

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

[Ianpbaker]

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

[gsc1ugs]

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

[Ianpbaker]

Ok
if you goto this thread from this morning it should sort out our problem


Ian

[gsc1ugs]

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

[gsc1ugs]

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?

[gsc1ugs]

what does that mean?

adCmdText - Evaluates CommandText as a textual definition of a command or stored procedure call.

[gsc1ugs]

LANPBAKER HELP