Data Transfer Workbench - Errors on final import - Rowset does not support fetching backward Hello All, I have an issue with data transfer workbench, currently running SAP 9.0 and DTW 9.2.1.
When going through the import wizard and getting to the end either running a simulation or selecting "Import" on the final wizard window the following messages appear (see attached).
The current record remains current after you call the method. Recordset Dim str Old First As String Dim str Old Last As String Dim str Message As String ` Open recordset with names from Employee table.
str Cnn = "driver=;server=srv;" & _ "uid=sa;pwd=;database=pubs" Set rst Employees = New ADODB.
Open str Cnn ' Open recordset with data from Employee table.
You can then display the error message using the Error Message property.Thank you in advance for the assistance,--John It seems that the error still happens after installing all SAP products and secondary programs.I asked the user to go through with the real production update in Data Transfer Workbench and they received the same error.If the number and order of fields and values do not match, an error occurs. str Message = "Edit in progress:" & vb Cr & _ " Original data = " & str Old First & " " & _ str Old Last & vb Cr & " Data in buffer = " & _ rst Employees! lname & vb Cr & vb Cr & _ "Use Update to replace the original data with " & _ "the buffered data in the Recordset? If the object supports batch updating, then you can cache multiple changes to one or more records locally until you call the ADO Recordset Object Update Batch Method. " If Msg Box(str Message, vb Yes No) = vb Yes Then rst Employees. lname = "Sornsin" ' Show contents of buffer and get user input. lname & vb Cr & vb Cr & _ "Use Update to save buffer to recordset? Cancel Update Msg Box "No new record added." End If ' Delete new data because this is a demonstration. Execute "DELETE FROM employee WHERE emp_id = '" & str Emp ID & "'" rst Employees.If you are editing the current record or adding a new record when you call the to save the changes. You must call the ADO Recordset Object Cancel Update Method if you want to cancel any changes made to the current record or to discard a newly added record. Open "SELECT fname, lname " & _ "FROM Employee ORDER BY lname", str Cnn, , , ad Cmd Text ` Store original data. But all information did load into the database properly.Still annoying with that error message would love to know what it is.