Posted by Erland Sommarskog on 10/19/09 11:26

vassone (vassone@gmail.com) writes:
> The code I'm using is below and this keeps giving me "Multiple-step OLE
> DB operation generated errors. Check each OLE DB status value, if
> available. No work was done."

The error is in the application code, not in the stored procedure. It
would help if you posted the part of the code where you call this
procedure. A typical case where you get this error is when you use the
ODBC call syntax: {? = call sp_insert_address(?, ?, ?)}, and provide
more parameters than you have ?.

But this very unhelpful message can appear in several other situations
as well. Whatever, the problem is not with the stored procedure - you
never come that far.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Return from store procedure.
• Prev in forum: Re: Return from store procedure.
• Thread view: Re: Return from store procedure.

[Reply to this message]