Report based on Stored Proc Timeout

B

Bill

I have a report in an Access 2002 ADP project that is
based on a stored procedure that runs on a SQL 2000
server. If the procedure takes less than 30 seconds to
run, the report displays fine. If it takes more than 30
seconds, the report doesn't display. I have checked the
timeout value of the connection, and it is much higher
than 30 seconds. I also checked the timeout in ADO and
it is greater than 30 seconds too.
 
B

Bill

This turned out an OLE/DDE timeout. You can set this on
the Advanced tab of Tools, Options.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top