Re: Timeout Expired

From: Henrique (progtecnic_at_hotmail.com)
Date: 02/28/05 

Date: 28 Feb 2005 11:18:55 -0800

Hi!

How can I set query timeout with DBExpress?

I know that with ADO components the CommandTimeout works...

Thanks,

Henrique.

Brian Bushay TeamB <BBushay@Nmpls.com> wrote:
>>Hi,
>> I always encounter the Timeout Expired error when i execute my query, why? how to solve it?
>>
>
>Set the commandtimeout property of your TAdoCustomDataset descendant
>
>If you are using D5. CommandTimeout property does not work for TadoQuery and
>TadoStoredProc. Use TadoDataset or TadoCommand
>--
>Brian Bushay (TeamB)
>Bbushay@NMPLS.com

Relevant Pages

  • Re: SqlCommand.CommandTimeout seems to have no effect
    ... I am trying to set the CommandTimeout property in the .NET SqlCommand object ... Running a query results in the query not terminating as expected, ... I was expecting to see an exception, ...
    (microsoft.public.dotnet.framework.adonet)
  • SqlCommand.CommandTimeout seems to have no effect
    ... I am trying to set the CommandTimeout property in the .NET SqlCommand object ... Running a query results in the query not terminating as expected, ... I was expecting to see an exception, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL Timeout Error
    ... and how do I set the CommandTimeout property? ... If the connection was established, you may need to set the CommandTimeout ... error message: timeout expired. ...
    (microsoft.public.sqlserver.server)
  • Re: Command Timeouts
    ... I meant the CommandTimeout property on the connection. ... ADODB.Connection and the ADODB.Command object have a CommandTimeout ... > Yes - I set the connection time to 500 seconds. ...
    (microsoft.public.sqlserver.programming)