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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yesss, it works!!!
Geo, sorry that I couldn't pay you the money (points) earlier :)
Yours,
Fat
Geo, sorry that I couldn't pay you the money (points) earlier :)
Yours,
Fat
ASKER
Yesss, it works!
Geo, sorry that I couldn't pay you the points earlier. Now get them :)
Yours,
Fat
Geo, sorry that I couldn't pay you the points earlier. Now get them :)
Yours,
Fat
Thank you so much, Fatman.
Best regards, Geo
Best regards, Geo
Have the same problem as well