Timeout

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I am running Microsoft Access 2002 as a front end to view reports from a IBM
DB2 database. This DB2 database can get very big and depending on a query
ran, the query can take some time to process as for all the records it has to
search through. I have been checking with my DBAs to get the DB2 database
optimized. When using the DB2 tools/client software, an SQL query through it
will return records after a decent amount of time (a few minutes) but if the
same query is run within access, it appears to get an ODBC call failure which
I am believing it to be a timeout. I have found within Access an OLE/DDE
timeout setting but can only max it out 300 seconds and I still get the ODBC
timeout. Is there anything else I can do to allow my queries to complete??
Are there ways to get around the timeout?? Are there newer versions of
access that won't timeout?? What can I do??

.

Relevant Pages

  • Re: Timeout
    ... I believe that a value of 0 for the timeout time will tell ACCESS to wait ... This DB2 database can get very big and depending on a query ... > same query is run within access, it appears to get an ODBC call failure ...
    (microsoft.public.access.queries)
  • Re[2]: Apparent BIND problem doing RBL lookups for Postfix
    ... query '33.229.242.205.zen.spamhaus.org/A/IN' approved ... 0x932e140): senddone ... 0x932e140: timeout ... 0x932e140: cancelquery ...
    (comp.protocols.dns.bind)
  • RE: Apparent BIND problem doing RBL lookups for Postfix
    ... At the first sight it seems network problems, but when you restart bind, ... query '33.229.242.205.zen.spamhaus.org/A/IN' approved ... 0x932e140: timeout ... 0x932e140: cancelquery ...
    (comp.protocols.dns.bind)
  • Re: sp timeout capture
    ... " If you set a query timeout for a query in Query Analyzer and the query ... you'll see an Attention event in Profiler" ... I thought i used sql profiler very extensively, ...
    (microsoft.public.sqlserver.tools)
  • Re: Problem using Access or Query Designer to run queries in SQL S
    ... The need for the group of financial analysts I support, is some ad-hoc query ... Therefore stored procedures called via pass-thru queries ... for their Access/Excel queries to fetch data from SQL server is still a huge ... I can instruct them to set the ODBC timeout ...
    (microsoft.public.sqlserver.odbc)