Timeout Expired error.

  • Thread starter Thread starter Sheetal Mahajan
  • Start date Start date
S

Sheetal Mahajan

Hi there!

I am using MSDE 2000 SP3, Sql.Net provider on Win2k server. When I try
to execute very simple query of inserting/selecting a row into a
table, I am getting following error,

"Timeout expired. The timeout period elapsed prior to completion of
the operation or the server is not responding."

This behaviour is not consistent. I have checked my code for not
leaving any connection open. Is there any limitation on number of
connections on MSDE? Or is it a problem with Sql.Net provider? Please
help me.

Thanks in advance.
 
Hi Sheetal
i think you can control the problem you have if you modify your connection
string .
in the connection string you can set the timeout properity of the
connection ... try to make it larger... it is defined in seconds
also you can set the max bool size to set the number of connection that can
exist in the connection bool . you can read more abou these properities on
this link
http://search.microsoft.com/search/results.aspx?View=msdn&st=a&qu=connection
+string+&c=0&s=1
 
Back
Top