Web Query -- Timeout Issue

[Guest]

Hi, I have a web query that retrieves data from a web site that posts daily
data. The issue I'm running into is when the data is not yet available the
web query does not timeout until at least 30 minutes (but it does timeout).
I've been trying to find work-arounds that would allow me to set a much
smaller timeout...say 1 minute. I've tried using background queries and
maintaining my own timer, but this seems to be a little buggy, and I've also
tried setting a registry timeout parameter but that didn't seem to work. Is
there a solution to this problem besides dropping the web query and using
either the XMLHttp or IE object? Thanks.

 

[Robin Hammond]

There is no timeout property on a web query. I've even punched this one back
to MS using a support incident (which they refunded because they couldn't
answer it).

Like you I also moved to background queries and a timer (you can find one on
my site) but it was desperately inefficient only being able to run a single
query at a time and highly unreliable.

For what I was doing I eventually ended up creating a custom built activex
control that uses the asyncread VB command. Initially I did it in VBA but
then moved the whole thing over to VB. The downside is you then have to
parse the html to get the data that you want.

As far as I could figure out the XMLHttp and Ie options provide a totally
synchronous download as well.

If you figure out an easier solution, let us know.

Robin Hammond
www.enhanceddatasystems.com