Results 1 to 4 of 4
  1. #1
    Join Date
    May 2004
    Posts
    25

    Unanswered: [Microsoft][ODBC SQL Server Driver] Timeout Expired

    Hello,
    I installed MS SQL Server 2000 Evaluation Edition on
    Windows XP Pro. I have database on the same PC. When I
    am running a query(view) from Query Analyser I
    get "[Microsoft][ODBC SQL Server Driver] Timeout Expired"
    error message . When I am running the same view on
    smaller amount of data it works.




    Could you please help me with that?
    Thanks
    DJ

  2. #2
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Cool [Microsoft][ODBC SQL Server Driver] Timeout Expired


  3. #3
    Join Date
    Jul 2004
    Posts
    6

    Wrong version

    The link in the previous post is for a connection timeout using SQL Server 7. It does not apply to running a query on SQL Server 2000.

  4. #4
    Join Date
    Jul 2004
    Posts
    6

    SQL Query Analyzer

    SQL Server 2000's default timeout period it 600 seconds (10 minutes). If you change it to zero (0), that's infinite. How long is it taking to timeout?

    If you run a long query through the Enterprise Manager, it will timeout after 30 seconds. MS's answer to this is to use the Query Analyzer (which should not timeout). I've run a 14-hour query through SQL Query Analyzer before.

Posting Permissions

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