Hi
I have some code where I use the api query object to call a stored procedure.
string result = api.query(@"dbo.get_manu_list", ref res);
This works on some of our machines but not others? I presume this is down to permission problem.
In this scenario what account does the query method pass to the SQL server?
TIA.
Given that when you call the SP you are not adding any parameters, I am not 100% sure where the permissions come into play. I'm tentatively assuming it will be windows authenticated. Can you confirm if there is an error message appearing when the SP fails?
Thanks,
Rich
I think you are right, you'd expect it to be all or nothing, not a mixture. I shall do some more digging.
Hi Andy,
Could you please confirm whether asnwer provided by Rich, worked or not. If yes, please make this post answered.
Answer Verified By: Carma De Villiers