adoquery and time-out

[Kudel]

Hi all

I’m connecting to a MSSQL db. I use an ado connection and an ado query

When I run my query in msQuery analyser it takes 50 sec, but when I activate my query in Delphi I get a time-out error after 30 / 40 sec.

How can I set my connection to never time out?

-Kip

 

[GHolden]

Hi,

You could increase the value for the ConnectionTimeout property for the ADO Connection. This is the time in seconds before the connection fails.



There are two ways to write error-free programs; only the third one works.