ADP Timeout Expired running Stored Procedure

[projnet]

I have a number of stored procedures on a SQL database. Most of these queries run OK, but two that I created today fail with a "Timeout Expired" message when run from within Access (2000). The same queries run fine using Query Analyser in SQL Enterprise tools. Others created today work fine in Access. I can't see a pattern in which queries work and which fail. I have checked the Connect Timeout setting in MS-Access

All queries were created in SQL Query Analyser.

Anyone else ever seen this?

 

[cmmrfrds]

How are you running the SP's from Access? Bound Form? ADO Command? How long does it take the queries that timeout to run in query analyzer?

 

[p27br]

hi

add this line to your code

cmd.CommandTimeout = 0

it will set the timeout to infinite, or you can set it to another value. see help

regards