Problem:

Message "Multiple-step OLE DB operation generated errors." received when calling SQL Server stored procedure using the ODBC driver.

Solution:

A Google search for "multiple-step oledb", suggest adding an entry called OLEDB_SERVICES under the key in the Windows Registry for the OLD/DB provider's CLSID. This was not the problem.
 
The second suggestion was to use the actual OLE/DB provider instead of the ODBC driver. With this change, the call to the stored procedure works.

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: December 10, 2016