Hi all,

I have received the error while executing the following lines which execute the stored procedure.


TestADOStoredProc.Connection.ConnectionString :=sConnectionString;
TestADOStoredProc.prepared;
TestADOStoredProc.Parameters.Refresh;
TestADOStoredProc.ProcedureName:='ExecAccount';
TestADOStoredProc.Parameters.ParamByName('Param1') .Value:='1';
TestADOStoredProc.Parameters.ParamByName('Param2') .Value:='2';
TestADOStoredProc.ExecProc();


any one help me is this correct way to execute the stored procedure

Hi,
Why do you set the ConnectionString of the tied ADOConnection component? Shouldn't you either untie the StoredProc from the Connection, change the Connection's ConnectionString and tie again? Or simply set the ADOStoredProc's ConnectionString and leave the Connection property blank? Don't know what method takes precedence if both are functional.

Regards,
Hans