Timeout Expired Message

[Guest]

Hello,

I have a report that gets its data from executing a stored procedure on a
SQL server 2k machine. However, it sometimes reports a "timeout expired"
message.

Is it possible to "trap" this error and report it back to the user (i use a
custom form with a docmd.open command that just closes the report when this
error occurs, and i dont think the on error goto works for this).

Also, is it possible to increase the timeout counter (or disable it
completely)? I know it wont go to infinity because of the coding for the
stored procedure. Just sometimes the server is slower than others.

thanks for any and all help!
Ben

 

[Guest]

Did you ever get an answer to your question? I have the exact same problem
on a contract I'm working on, and haven't been able to figure it out yet. I
didn't do the original report, and for the time being just need to get it to
run (I will optimize it later).

 

[Guest]

nope. havent recieved an answer yet. what i did was write a new stored
procedure that created a table and set the timeout on the running of that
stored procedure to 0 and then just based the report off the table

 

[Guest]

I can't seem to find where to set that. I have gone into design mode on the
stored procedure but there is no properties access.

I have tried using a view, and although there are properties when I bring it
up in the designer, there is no timeout field.

 

[Guest]

Sorry, i didnt make the last comment clear. I can set the timeout value for
executing a stored procedure through msaccess's vb code, but not for running
a report.