Posted by vassone on 10/20/40 11:27

Hi Erland,

Thanks for your response. This is the code I'm using from teh ASP page, I've
hard wired the variables for testing purposes.

Any help would be very much appreciated.

strSQL= "EXECUTE heasvase.up_insert_address
val1,val2,val3,val4,val5,val6,val7"
Call OpenDB("rs","objDBConn",strSQL)



"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns96D011F5D8B7Yazorman@127.0.0.1...
> 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: sqlmaint.exe failed
• Thread view: Re: Return from store procedure.

[Reply to this message]