Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 928
  • Last Modified:

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
0
Fatman121898
Asked:
Fatman121898
  • 2
  • 2
1 Solution
 
wimmeyvaertCommented:
Interesting ...
Have the same problem as well
0
 
geobulCommented:
Hi F(B)atman,

Use TADODataSet component instead of TADOStoredProc. Write the SQL expression (stored proc) in its CommandText property. Set TADODataSet.CommandTimeout property to the desired value or 0 (infinite).

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

Best regards, Geo
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now