Information générale
Catégorie:
The Mere Mortals .NET Framework
Titre:
Long Running SQL Server Queires
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement