How to Handle a Timeout error

From: Bill N (bnielsen_at_cpumanagement.com)
Date: 08/24/04 

Date: 24 Aug 2004 12:44:41 -0700

I've created an Client/Server Application using D6 SP2 and all seems to
work well except on one client who has a farm of citrix servers (6
machines) with a database server with MSDE on the machine.

The client has been experiencing timeouts. I would like to know:
=================================================================
1) How I can I determine whether it is the TADOConnection that is
timing out or a specific query?
2) If it is a specific query that is timing out, which one?
3) Other than increasing the CommandTimeout property, is there
anything that I can do to prevent timeouts?
=================================================================

Thanks,
Bill N

Relevant Pages

  • Re: Union Query works on my PCs but not on clients machines
    ... will check all that out next time I visit the client. ... > To check the file versions between the two machines, ... The query contains undeclared parameters, ... >> office machines and updated it in the same way I updated my home PC. ...
    (microsoft.public.access.queries)
  • Re: How to Handle a Timeout error
    ... >work well except on one client who has a farm of citrix servers (6 ... >machines) with a database server with MSDE on the machine. ... >The client has been experiencing timeouts. ... No increase commandtime out is your only options. ...
    (borland.public.delphi.database.ado)
  • Re: Record Count Inconsistent
    ... show up when the file was accessed from the client end. ... The same query ("select * from QryReport) is run from all ... machines. ...
    (microsoft.public.access.queries)
  • RE: Collection not showing ALL of the clients correctly
    ... If I'm not getting hardware inventory then the client is not ... through the query to create a new collection and that seemed to work. ... added the other machines that have not been showing up as "Direct" and I now ...
    (microsoft.public.sms.admin)
  • Re: Collection not showing ALL of the clients correctly
    ... If I'm not getting hardware inventory then the client is ... "David M" wrote: ... Change your query to: ... I right clicked on one of the machines that I have been having ...
    (microsoft.public.sms.admin)