Solved

TADOConnection timeout > 30 sec. impossible?

Posted on 2002-04-11
5
773 Views
Last Modified: 2009-07-29
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
Comment
Question by:Fatman121898
  • 2
  • 2
5 Comments
 
LVL 6

Expert Comment

by:wimmeyvaert
ID: 6934175
Interesting ...
Have the same problem as well
0
 
LVL 17

Accepted Solution

by:
geobul earned 50 total points
ID: 6936635
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
 
LVL 1

Author Comment

by:Fatman121898
ID: 7082989
Yesss, it works!!!
Geo, sorry that I couldn't pay you the money (points) earlier :)
Yours,
Fat
0
 
LVL 1

Author Comment

by:Fatman121898
ID: 7082995
Yesss, it works!
Geo, sorry that I couldn't pay you the points earlier. Now get them :)
Yours,
Fat
0
 
LVL 17

Expert Comment

by:geobul
ID: 7083062
Thank you so much, Fatman.

Best regards, Geo
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now