Sql connection Time out

Question

Hi Friends,
               Is it possible execute  insert statement at same milliseconds and same Table. i got strange error like this
Sql connection Timeout.

Any Idea.

Answer 1

Hello Dheeraj,

Would you please share us the technology you're using and the detailed error message?

Thanks,
Hooray

Answer 2

Hi ,
      Sql server 2005 and .Net 2.0

Thanks

Answer 3

Can you please share some sample code and the exact error message?

---

This posting is provided "AS IS" with no warranties, and confers no rights

Answer 4

Hi Raj,
          Please go through my scenario carefully.

1) My application have N number of threads running Background each thread have its own sets of Sql Statement like(Insert,Update....& Stored Procedure).
2) My application is based on OLTP(in one seconds 48 transaction may happen)

could pls help me what are all factors i need to look up?

Thanks

Answer 5

Can you please post the error message?

---

This post is provided 'as is' and confers no express or implied warranties or rights.

Answer 6

Hi,

>Is it possible execute  insert statement at same milliseconds and same Table. i got strange error like this
>Sql connection Timeout.

For insert operation, the command will be queued, and for update operation you can try the concurrency control.

Based on the error "SQL connection Timout", what is the connection timeout value you set now and have you tried to increase that value?

---

Microsoft Online Community Support Please remember to mark the replies as answers if they help and unmark them if they provide no help.