StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » ExecuteStoredProcedure( ) and Timeouts

ExecuteStoredProcedure( ) and Timeouts

Alex Luyando — Tue, 21 Jul 2009 15:17:57 GMT

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

RE: ExecuteStoredProcedure( ) and Timeouts

Trent L. Taylor — Tue, 21 Jul 2009 15:17:57 GMT

[quote]Thanks for the quick reply, Mr. T.
[/quote]

Makes me want to go out and buy a bunch of gold necklaces and put a huge ring on every finger! :D

RE: ExecuteStoredProcedure( ) and Timeouts

Alex Luyando — Tue, 21 Jul 2009 14:21:02 GMT

Thanks for the quick reply, Mr. T.

RE: ExecuteStoredProcedure( ) and Timeouts

Trent L. Taylor — Tue, 21 Jul 2009 13:33:05 GMT

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. :)