what is "Multiple-step operation generated errors" Run-time error (80040e21) ?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: luZ (luz_at_simba.com)
Date: 05/31/04 

Date: Mon, 31 May 2004 14:51:30 -0700

I have a generic ODBC driver. I am using ADO from VB to update a table in my
database, see the following VB program:

    Dim rs As ADODB.Recordset
    Set conn = New ADODB.Connection
    conn.CursorLocation = adUseClient
    conn.Open "DSN=Codebase Sample Release DSN"

    If conn.State = adStateOpen Then
        Set rs = New ADODB.Recordset
        rs.Open "select * from st1 order by f_name", conn,
adOpenForwardOnly, adLockPessimistic <--- if i do not have "oder by", it
works fine.

        List1.Clear
        rs.MoveFirst
        Do While Not rs.EOF
            rs.Fields("f_NAME").Value = "sm"
            rs.Update
            rs.MoveNext
        Loop
        rs.Close

        Set rs = Nothing
        conn.Close
    End If

Table st1 only has a char(15) colloumn.

  the error i get is: "Multiple-step operation generated errors" Run-time
error (80040e21)

can anyone help?

Lu

Relevant Pages

  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Requery of Listbox does not display new data
    ... add a record to the database. ... Then the Lisbox control's requery method is ... The ADO command is run using a connection string to the mdb containing the ... Dim cmd As ADODB.Command ...
    (microsoft.public.access.formscoding)