Timeout

[Doug Taylor]

I have a OWC 10 chart that pulls data from a SQL 2000
server. The query on which it is based takes between 25
and 50 second to run, depending on how busy the server is.

The problem is from what I've read the default timeout in
waiting for results to populate the table is 30 seconds.
So most of the time users try to view my chart, it times
out.

All of the information I've read seems to indicate that
there is a command timeout setting that by defaul is at
30 sec. However in my development world I can't find
where I can change this setting. It's a OWC chart on an
Access Data Access Page designed from within an Access
Data Project which I'm using to interface with the SQL
server. This is frustrating because I feel as though I'm
on the verge of fixing this, but I just can't find where
to edit the command timeout property!

Any suggestions or direction would be most welcome.

Thanks,

Doug Taylor
Plano, TX

 

[Doug Taylor]

I still haven't found how to adjust the timeout, but I
did do the "right" thing and learn a bit more about query
efficiency. I added some indexes to my tables on the FK
columns which seemed to help. Most of my queries are now
running under 30 seconds, so I'm not getting the time out.

However if anyone stumbles across this message and knows
the answer to my original question, I would be most
grateful for a response.

Thanks,

Doug

 

[Alvin Bruney]

what was your original question?