Link to home
Start Free TrialLog in
Avatar of Fatman121898
Fatman121898

asked on

TADOConnection timeout > 30 sec. impossible?

Hi there,

I'm trying to execute stored procedure on Microsoft SQL Server 2000 via TADOConnection and TADOStoredProcedure components. Every time when the stored procedure execution needs more than 30 seconds, I receive message 'Timeout expired'. Server Admin told me that the server settings do not impose any timeouts (timeout is infinite).
Setting ConnectionTimeout and CommandTimeout on TADOConection component does not help at all.

My question: are here some details that I've missed setting ADO connection?

Thanks
Avatar of wimmeyvaert
wimmeyvaert

Interesting ...
Have the same problem as well
ASKER CERTIFIED SOLUTION
Avatar of geobul
geobul

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Fatman121898

ASKER

Yesss, it works!!!
Geo, sorry that I couldn't pay you the money (points) earlier :)
Yours,
Fat
Yesss, it works!
Geo, sorry that I couldn't pay you the points earlier. Now get them :)
Yours,
Fat
Thank you so much, Fatman.

Best regards, Geo