How to handle the ADO timeout ?
I'm having a report with 4 dade datasources.
Delphi 6, RB 7.03 over ADO to Sql Server.
One of the queries takes quite some time, over 1 min. This is normal due to
the complexity of the view that we select on.
The problem is that the server times out on this query. Wich could be normal
as the default in ADO is 30 seconds.
But, in the server i've set the property of the ado connection to 1800, in
the application on with i develop my reports and store them in a database
i've set the ADOConnection.Commandtime out to 1800 to.
Nothing of this helps, what could be normal, i suppose that dade is creation
a TADOQuery of TADODataSet to launch his queries. But these objects also
have a commandtimeout property.
How can i solve this, or what am i doing wrong ??
Kind Regards
Delphi 6, RB 7.03 over ADO to Sql Server.
One of the queries takes quite some time, over 1 min. This is normal due to
the complexity of the view that we select on.
The problem is that the server times out on this query. Wich could be normal
as the default in ADO is 30 seconds.
But, in the server i've set the property of the ado connection to 1800, in
the application on with i develop my reports and store them in a database
i've set the ADOConnection.Commandtime out to 1800 to.
Nothing of this helps, what could be normal, i suppose that dade is creation
a TADOQuery of TADODataSet to launch his queries. But these objects also
have a commandtimeout property.
How can i solve this, or what am i doing wrong ??
Kind Regards
This discussion has been closed.