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

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.

Thanks for the quick reply, Mr. T.

________________
_____/ Regards,
____/ al

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