Hi,

I am using Visual studio integration and I need to call a stored procedure. I used

 Process.ExecuteStoredProcedure(string procedure, object[] inputObjects, ref object outputObjects, string connectionString)

But it doesnt work. I used it like this;

object res = process.ExecuteStoredProcedure("SELECTALLUSERS", parameters, ref outputs, connectionString);

The problem is that  method always returns 0 and also outputs is not changing.

Could you tell me how I can use this method?

Thanks..

You are having the workflow server process execute the stored proc. Does that user have the rights to do so? May be easier to come up with a method that execs your stored proc outside of the workflow server.

---

Matthew Williams
Captaris International Trainer
Vianen, Netherlands
blog: technovangelist.com