Timeout expired

Results 1 to 2 of 2

Thread: Timeout expired

  1. #1
    Join Date
    Dec 1969
    Posts
    9

    Default Timeout expired

    hi,<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e31&#039 <BR>[Microsoft][ODBC SQL Server Driver]Timeout expired <BR><BR>i got the above error and even after i changed the Connection object&#039s ConnetionTimeout property to a higher value, i got the error again.<BR><BR><BR>Please advise.<BR><BR>Regards,<BR>Shruthi.<BR><BR><BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    1,019

    Default RE: Timeout expired

    I&#039ve experienced this problem before. Causes were:<BR>1. SQL server overworked or a lot of Disk I/O instead of caching all the query processes. Beef up the RAM or processor.<BR>2. Someone else&#039s (or your) query or the administrator has the server too busy to process your query. Check the current sever activity when this happens to find the culprit.<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •