>I see that message a lot too, always when the query draws a large result set or when the server is under heavy load.
>
>My 'guess' = Perhaps changing the "timeout" settings in the connection designer will fix it.
>
>>Is there any way to keep the
>>"Executing Remote... Press ESC to cancel."
>>message from appearing when you call SQLEXEC() to run a query against a remote source?
If you mean the ConnectionTimeout property, that has to do with the time to wait for the ODBC connection to respond, not how long it takes for a query to run.
Thanks for the response!
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
