ADO.NET SQL SERVER ERROR

  • Thread starter Thread starter Meiny
  • Start date Start date
M

Meiny

When I'm Runung An insert Sql Stored procedure on SQL
SERVER in my program ,after some seconds this message is
handled.
I have tested this SP on Query Analyzer more and more,the
execution time in Query Analyzer is about 45 seconds.and
works properly
But in my program , the progarm stops responding and then
this exception thrown.
the original message is:
"Timeout expired. The timeout period elapsed prior to
completion of the operation or the server is not
responding."
 
Did you set the timeout on the command? The default is 30 seconds, so if it
spends 45 seconds, then you will get a timeout.

Arild
 
Back
Top