Re: Finding out which query timed out

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 10/29/04

  • Next message: Brian Bushay TeamB: "Re: BetterADODataSet installation"
    Date: Thu, 28 Oct 2004 21:21:40 -0500
    
    

    >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'?
    I can't find anything on that Error number.
    What code in your system is generating the error messages? This is not a
    standard error Delphi generates

    --
    Brian Bushay (TeamB)
    Bbushay@NMPLS.com
    

  • Next message: Brian Bushay TeamB: "Re: BetterADODataSet installation"

    Relevant Pages

    • Re: Resyncing Inserts
      ... >I am having a lot of trouble with using default values in an SQL 2K db. ... Brian Bushay (TeamB) ...
      (borland.public.delphi.database.ado)
    • Re: Use query or stored procedure
      ... Since the SQL is an insert statement and returns no records a TadoCommand is the ... Brian Bushay (TeamB) ...
      (borland.public.delphi.database.ado)
    • Re: Adding field to table
      ... Use SQL ... Here is the reference ... Brian Bushay (TeamB) ...
      (borland.public.delphi.database.ado)
    • Re: CheckMod.db
      ... >>How can I write this query passing over the error caused by the ... >> with SQL do ... > Brian Bushay (TeamB) ...
      (borland.public.delphi.database.ado)
    • Re: Append results from ADODataset
      ... I wanted to move the data with SQL ... ... > TeamB cannot answer questions received via email ... > Del M wrote: ... >> append more data to it. ...
      (borland.public.delphi.database.ado)