Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

Question

Muana Ralte 21

Hui Liu-MSFT 48,711 Reputation points Microsoft External Staff

2021-10-04T01:54:06.743+00:00

Hi,@Muana Ralte . This error will occur when you try to submit data to the database. This may be when you use the .Execute() method of the ADO Connection object to execute a SQL string, or when you call the .Update() method of the Recordset. Could you show the code that you use the database? You can also check here if the answer is helpful to you.
Muana Ralte 21 Reputation points

2021-10-04T05:32:31.067+00:00

137312-my-code.txt

This is my code
Hui Liu-MSFT 48,711 Reputation points Microsoft External Staff

2021-10-07T07:54:46.49+00:00

Hi,@Muana Ralte . This problem may occur when you try to insert too much data in the specified field. For example, if you enter a string of 20 characters in a field defined as varChar(10), or if you try to insert a value greater than 215 (approximately 2.1 billion) into an Integer field. Does the data type of the data you insert match the data type of the corresponding field in the database?
Muana Ralte 21 Reputation points

2021-10-07T08:46:31.007+00:00

My teachers already solved it for me thank you for your time
Henry Ukonze 11 Reputation points

2022-09-08T15:34:21.66+00:00

Please what was your solution from you teacher if you recall. I am going through the same issue presently.

Your answer

Hui Liu-MSFT 48,711 Reputation points Microsoft External Staff

2021-10-04T01:54:06.743+00:00

Hi,@Muana Ralte . This error will occur when you try to submit data to the database. This may be when you use the .Execute() method of the ADO Connection object to execute a SQL string, or when you call the .Update() method of the Recordset. Could you show the code that you use the database? You can also check here if the answer is helpful to you.
Muana Ralte 21 Reputation points

2021-10-04T05:32:31.067+00:00

137312-my-code.txt

This is my code
Hui Liu-MSFT 48,711 Reputation points Microsoft External Staff

2021-10-07T07:54:46.49+00:00

Hi,@Muana Ralte . This problem may occur when you try to insert too much data in the specified field. For example, if you enter a string of 20 characters in a field defined as varChar(10), or if you try to insert a value greater than 215 (approximately 2.1 billion) into an Integer field. Does the data type of the data you insert match the data type of the corresponding field in the database?
Muana Ralte 21 Reputation points

2021-10-07T08:46:31.007+00:00

My teachers already solved it for me thank you for your time
Henry Ukonze 11 Reputation points

2022-09-08T15:34:21.66+00:00

Please what was your solution from you teacher if you recall. I am going through the same issue presently.