I'm trying to create a Windows Forms interface to launch end of month queries, each of which requires several minutes to generate results. I have a stored procedure (query) that requires app. 2-3 minutes running time in SQL Server. It runs fine in Query Manager, but when I run it directly from a C# app. in app. 30 seconds I get the error message: The timeout period elapsed prior to completion of the operation or the server is not responding.

My ConnectionString sets the timeout=0. Any idea on what other settings might be causing this problem?

Note: if I replace the stored procedure with a query that takes only a few seconds, I get my results and do NOT get the error message.

I'm using C# and the Mere Mortals .Net framework.

Tim