Query Timeout in form only

  • Thread starter Thread starter Karen Barrett
  • Start date Start date
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.
 
I had a similar experience like yours but with MS-SQL Server so I am not
sure whether my solution is applicable to you.

In my case, the Pass-through Query worked fine when I open the Query by
itself but not as the RecordSource of the Form. Eventually, I tracked down
the problem was that I didn't specify the communication mode in the ODBC
Connection String. Somehow it worked fine when I open the Query by itself
but not as the RecordSource of the Form. When I included the communication
mode (TCP/IP with port number) in the Connection String, the Query worked
fine through the Form.
 
Thanks for your reply Van. I did not have an explicit
connection string in my form. Strangely, I deleted a
bunch of old tables and queries out of the Access front
end (decreased from 70M to 23M), re-ran the application
and voila! No timeout.
 
Back
Top