Timeout Expired error.

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.
 
M

Mohamoss

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
 

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

Error: Timeout expired. The timeout period elapsed prior to comple 3
Help - why does SqlException not list Procedure name on timeout? 1
Query Timeout Expired Using SELECT/WHERE 5
Timeout expired on Insert 7
Connect without async but get timeout error when async=true 5
DataAdapter.Fill(Dataset) shows timeout error. 2
Timeout expired error 1
SqlClient TimeOut Issues In Asp.Net Only 7

Top