Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    1

    Unanswered: Problem in Stored procedure...

    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

  2. #2
    Join Date
    Aug 2006
    Location
    The Netherlands
    Posts
    248
    Hi,
    TestADOStoredProc.Connection.ConnectionString :=sConnectionString;
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •