ExecuteStoredProcedure( ) and Timeouts

Author	Message
Trent Taylor	Trent Taylor posted 15 Years Ago Post Details Share Post
Group: StrataFrame Developers Posts: 6.6K, Visits: 6.9K	Thanks for the quick reply, Mr. T. Makes me want to go out and buy a bunch of gold necklaces and put a huge ring on every finger!
	Reply Like 0
Alex Luyando	Alex Luyando posted 15 Years Ago Post Details Share Post
Group: StrataFrame Users Posts: 112, Visits: 1.2K	Thanks for the quick reply, Mr. T. ________________ _____/ Regards, ____/ al
	Reply Like 0
Trent Taylor	Trent Taylor posted 15 Years Ago Post Details Share Post
Group: StrataFrame Developers Posts: 6.6K, Visits: 6.9K	You will have to set this at the command level. In truth, you are better off doing this anyway as you will have more overall control of the execution. So you will need to create an SqlCommand and set the timeout at that level.
	Reply Like 0
Alex Luyando	Alex Luyando posted 15 Years Ago Topic Details Share Topic
Group: StrataFrame Users Posts: 112, Visits: 1.2K	Hi all - I see postings that discuss using SQLCommand.ConnectionTimeout to prevent connection timeouts for long-running stored procedures. Is it possible to do the same with MicroFour.StrataFrame.Data.DataBasics.DataSources[""].ExecuteStoredProcedure( )? If not I'll just recode to use a SQLCommand object, but it would be nice if that wasn't required... TIA ________________ _____/ Regards, ____/ al
	Reply Like 0