ADO.NET SQL SERVER ERROR

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."
 
A

Arild Bakken

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

damn messag"Timeout expired.The timeout period elapsed prior to completion of th 2
Time Out Error 2
The timeout period elapsed ... 2
Connection timeout when using SQL Server User Instance 3
sql timeout from web application problem (works good in sql server 2
Timeout on "DataAdapter.Fill" 2
two threads 2
SQL Reader Again 8

Top