Timeout while running SQL Stored Procedure

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?
LVL 1
wsturdevAsked:
Who is Participating?
 
ptjcbConnect With a Mentor Commented:
Time out is buried in SQL Server Management Studio

Management Studio > Tools > Options > Designers

Change the default transaction time out there.
0
 
wsturdevAuthor 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?
0
 
ptjcbCommented:
What is the exact timeout message?
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
>Provider=sqloledb;Data Source=n.n.n.n;Initial Catalog=DBName;Connection Timeout=600;UID=myuserid;PWD=mypwd
you set the connection timeout, but what you need is the command timeout, which is also 30 seconds by default.

using the adodb.command object, set the commandtimeout property of that object to 600 before executing the command (procedure)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.