>  I'm not an Impromptu user so this may be way off the mark, but is there
>a setting within the client (Impromptu) as to the amount of time it will
wait
>on the server to complete a transaction?  In many pieces of the client S/W
>I've used there exists such an "escape" mechanism to keep the user from
>doing a 'million row retrieval' :)
>  If not, try turning some of the various trace options on to get a view of
what
>each piece thinks the other is doing during this time (like, is it
returning the
>tuples to the client, or is ODBCLink/SE waiting for Allbase to process the
>query).  If it's returning the data to the client, maybe your running out
of
>memory and the message is bogus (that's a technical term for "in error" :)

As a former Impromtu user, and hopefully soon to become a current one
again - Mike, you are on the mark.

Most of the AdHoc and EIS tools such as Impromptu and Powerplay have this
setting, to do just what you said - keeping the "query from hell" from
usurping the machine.

That's the first place I would go - and yes, I would do the trace as well...

Joe

Joe Geiser - CSI Business Solutions, LLC
** Your Client-Server and Internetworking Specialists
140 Bristol-Oxford Valley Road, Suite 102
Langhorne, PA  19047-3083, USA
Phone: +1 215.945.8100   Fax: +1 215.943-8408
[log in to unmask]            http://www.csillc.com