ADO Error While Executing Command To Recordset

Hi,

On the line

Set RS = Cmd.Execute

I get this error

Capture.GIF

Can anyone tell me what might be wrong..

Here is the full code -

Please Login or Register  to view this content.

This is almost certainly an issue with your SP, not VBA or ADO. See for example: http://stackoverflow.com/questions/2...begin-and-comm

But If I copy values from the Parameters in Excel and Run it in the stored proc directly using SSMS, it works just fine..

Do you want the Stored Proc?

Here is the piece of code that executes the SP

Please Login or Register  to view this content.

Oh Sorry..

I go to the Object Explorer > Find the stored Proc > Right Click On the SP Name > Input the Parameters > Execute

On issue which I found is,

Set RS = Cmd.Execute line should be Cmd.Execute.

As there is no recordset, the SP just affects certain rows, and there another Select statement that returns data..

Even when I directly do it, it still runs.. (Shortened Version Of the XML)

EXEC DB_Common..SPName '<PType>VANILLA</PType><Solve>PREMIUM</Solve>', 'Bank1';

Hi,

I found out the issue. It was my fault, the 2nd parameter was generating incorrectly..

I am extremely sorry for wasting your time..

Marking the thread as solved..