Finding out which query timed out

From: Bill N (bnielsen_at_cpumanagement.com)
Date: 10/28/04

  • Next message: Scott Leake: "BOF or EOF when closing TADOQuery" 
    Date: 28 Oct 2004 13:17:16 -0700

    I'm using D6 Enterprise SP2.

    I'm getting this error:

    ******ADO Errors*******
    *Error Number: -2147217871 *
    *Source: Microsoft OLE DB Provider for SQL Server
    *Description: Timeout expired
    *Native Error: 0
    *SQL State : HYT00
    ***********************

    Is there a way to determine which query timed out? Also what is 'SQL
    state: HYTOO'?

    Thanks,
    Bill N

  • Next message: Scott Leake: "BOF or EOF when closing TADOQuery"

    Relevant Pages

    • Re: Method cleanup failed while trying to execute method cleanup on ManagedConnection
      ... JDBC driver name: Microsoft SQL Server 2005 JDBC Driver ... Our application seems to be working fine but every time a connection is closed we get a stack trace in the log indicating that destroy failed and that a method is not supportd with "Caused by: java.sql.SQLException: This operation is not supported.DSRA0010E: SQL State ... We have used the same set up but using the SQL Server 2000 JDBC driver talking to a SQL Server 2000 database without a problem, the only difference is we switched it to use SQL Server 2005. ...
      (microsoft.public.sqlserver.jdbcdriver)
    • Re: Sql Sever CE 3.0 does not work after making call to embedded c
      ... I have been able to isolate the line of code in the embedded c++. ... I already tried preloading sql and it still breaks. ... >> The native error suggests: ... >>> I did not have this problem using the exact same code with Sql Server CE ...
      (microsoft.public.sqlserver.ce)
    • Re: Problem with SQL CE, select with sum and SqlCeResultSet
      ... Interestingly in SQL Compact 3.5, although Top is supported as a keyword, you have to include the parentheses whereas for SQL Server they're optional. ... I do a simple select query with one join and sum on field value. ... ,,] Native Error: 25901 ...
      (microsoft.public.dotnet.framework.compactframework)
    • SQL Server Error:10061 and SQL Server Error:17
      ... I am getting the following errors when I try to connect to SQL from a SQL ... SQL State '01000' ... SQL Server Error:17 ... Prev by Date: ...
      (microsoft.public.sqlserver.connect)
    • SQL Replication problem
      ... tested Mobile replication successfully. ... Native Error:29006 ... A call to SQL Server Reconciler failed. ...
      (microsoft.public.sqlserver.replication)