We help IT Professionals succeed at work.

Timeout while running SQL Stored Procedure

wsturdev
wsturdev asked
on
3,971 Views
Last Modified: 2012-08-13
I am running SQL Server 2005.  As far as I can tell the remote query timout for the server (all databases) is 600 seconds.

I am running an Access front-end with the following connection string:
Provider=sqloledb;Data Source=n.n.n.n;Initial Catalog=DBName;Connection Timeout=600;UID=myuserid;PWD=mypwd

When I run a stored procedure that will take at least 1 minute, it always times out after 30 seconds.  What am I missing?
Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
I went there and changed it to 600 seconds, and the timeout still happens after 30 seconds.

Also, are you saying there would be no way to set the timeout to "normal" and override it when needed?

Commented:
What is the exact timeout message?
Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.