odbc driver timeout expired

odbc driver timeout expired

Post by Sun » Mon, 04 Jun 2001 03:30:18



I connect to SQL 2000 on windows 2000 by ODBC.The records in a table reach more
than 50,000,000,but it always report [Microsoft][ODBC SQL Server driver]Timeout
expired.
How to fix the problem?

Sun

 
 
 

odbc driver timeout expired

Post by Gabriel Godoroj » Fri, 22 Jun 2001 00:58:06


      Maybe this will help you:

      The information in this article applies to:

        a.. Microsoft SQL Server 2000 Analysis Services, version 8.0

--------------------------------------------------------------------------
      BUG #: 11406, 12157 (plato7x)

      SYMPTOMS
      When performing an incremental update on an Analysis Services cube using the Analysis Services DTS Processing Task, the incremental update may fail with a timeout error if the fact table is large.

      The DTS Package log will show the following error information:

        Step Error Source: Microsoft OLE DB Provider for SQL Server
        Step Error Description:Timeout expired
        Step Error code: 80040E31 Step Error Help File:
        Step Error Help Context ID:1000440

      CAUSE
      The incremental update process creates a temporary partition to hold the new data for the cube. This temporary partition is then populated with the new data and merged with the existing partition for the cube. During the creation of the temporary partition, the DTS task attempts to get a record count from the fact table for the cube. If this count is not returned within 30 seconds, the connection returns a timeout error and the DTS task is unable to continue.

      Because the partition created by the DTS Processing Task is temporary and is removed after being merged with the existing partition, the count of the fact table is not necessary and has been removed from the partition creation sequence.

      RESOLUTION
      To resolve this problem, obtain the latest service pack for the Microsoft SQL Server 2000 (the Analysis Services Components - Sql2kasp1.exe). For additional information, please see the following article in the Microsoft Knowledge Base:

        Q290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
      Hotfix
      NOTE: The following hotfix was created prior to Microsoft SQL Server 2000 Service Pack 1.

      The English version of this fix should have the following file attributes or later:
   Date        Time    Version     Size      File name  
   ----------------------------------------------------

   3/14/2001   9:01p   8.0.0.267   368,716   Msmdtsp.dll
      NOTE: Due to file dependencies, the most recent hotfix or feature that contains the above files may also contain additional files.

I connect to SQL 2000 on windows 2000 by ODBC.The records in a table reach more
than 50,000,000,but it always report [Microsoft][ODBC SQL Server driver]Timeout
expired.
How to fix the problem?

Sun

 
 
 

1. SQL ODBC Driver Timeout expired

I have windows 2000 server installed with SQL 7.0 with no service pack
installed. when i run some application queries, most of the time i get error
as SQL ODBC Driver Timeout expired. Runtime error.

The server is IBM Dual P III processor with 1024 MB RAM. I donot see any
processor utilization or memory ultilization while query running

Can any body suggest me an best solution!
Regards,
Kani

2. Multiple Databases on different platforms

3. ODBC Driver Timeout Expired Error

4. Recovering the Data from DBF files

5. Microsoft SQL Server Login-Connection Failed-Microsoft ODBC Driver-Timeout Expired

6. newbie--class property let and get

7. odbc driver timeout expired with asp

8. Access 2000 set database password

9. category:odbc,source:odbc sql server driver,number:s1t00(timeout expired)

10. ODBC SQL Server Driver: Timeout Expired (80040e31)

11. [ODBC SQL Server Driver]Timeout expired

12. ?[microsoft][ODBC SQL Server Driver] Timeout expired