BorlandTalk.com

Bill N · Guest

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

Bill N · Guest

Del Murray · Guest

Bill,
Did you wrap your queries in a try..except block ??? in the except block you
can trap the timeout error.

Bill N · Guest

Del Murray wrote:

Del Murray · Guest

Do you have each query.open in a try .. except or are you using a global
exception handler. I put each one in a try except, that way I know which one
is failing. I do this ...

try
qryDataSet.close;
qryDataSet.commandtext := blah blah blah // or what ever,
qryDataSet.Open
except'
on e:exception do begin
showmessage(e.message);
end;
end;

This seems crude, but if an "open" fails that means that their is something
bad wrong. the e.message will tell you what. It may be a timeout but may be
something else. What ever it is, I dont want to just handle timeouts, I want
to know why any failure took place and this gives it to me.