"Multiple-step operation generated errors"
Hi,
I am using ADO 2.5 in Excel XP to build a recordset from the rows in my worksheet, then update a DB2 database with the recordset's contents. This is something I've been able to accomplish before in other workbooks, but not this time. When my code attempts to execute the ".update" method, I receive the following error. Error: -2147217887 Description: Multiple-step operation generated errors. Check each status value. This is a new one on me, and I have no idea where to begin. Any ideas? Thanks, Michael |
Nevermind
FYI
Turns out I was trying to insert a record whose unique key matched a record that already existed in the database table. -----Original Message----- Hi, I am using ADO 2.5 in Excel XP to build a recordset from the rows in my worksheet, then update a DB2 database with the recordset's contents. This is something I've been able to accomplish before in other workbooks, but not this time. When my code attempts to execute the ".update" method, I receive the following error. Error: -2147217887 Description: Multiple-step operation generated errors. Check each status value. This is a new one on me, and I have no idea where to begin. Any ideas? Thanks, Michael . |
"Multiple-step operation generated errors"
The error is the generated in a variety of situations. I most often
see this when an amended recordset value is of the wrong data type for the column e.g. trying to update a not null column with a null. As the message says, check the values you are trying to update the database with to ensure they are valid. -- "Michael Daly" wrote in message ... Hi, I am using ADO 2.5 in Excel XP to build a recordset from the rows in my worksheet, then update a DB2 database with the recordset's contents. This is something I've been able to accomplish before in other workbooks, but not this time. When my code attempts to execute the ".update" method, I receive the following error. Error: -2147217887 Description: Multiple-step operation generated errors. Check each status value. This is a new one on me, and I have no idea where to begin. Any ideas? Thanks, Michael |
All times are GMT +1. The time now is 01:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com