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?