Query timeout in forms routine only

K

Karen Barrett

I have an application where the form builds a querydef,
then runs it (multiple times). The data comes from a
single linked Oracle table. Often the query will timeout
(ODBC Call Failed, Oracle's "user cancelled requested
operation" message). When I go into debug, then run the
query manually there is no problem (and the query has
timeout = 0).

Any ideas? I even tried setting qd.ODBCTimeout = 0
immediately before qd.SQL.
If you'd like to reply offline, my email is
(e-mail address removed)

Thanks for your interest.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top