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

Henry Ukonze 1 Reputation point
2022-09-08T15:45:08.92+00:00

I am having an issue with SQL/VBA for reporting in a SCADA system. I believe the custom batch reporting VBA scripts related to FT Batch (VBA scripts are on the graphics) are the culprit. See attached VBA scripts.

Error shown is "GenerateReport():Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."

239173-scripts.txt