Results 1 to 2 of 2

Thread: ODBC Timeout

  1. #1
    Join Date
    Jun 2004
    Location
    NYC Area
    Posts
    24

    Unanswered: ODBC Timeout

    I have a report that uses SQL code as the record source, which points to two SQL views linked via ODBC. If I run the code while in the query builder it returns the record set in about 90 sec's, but when I try to open the report I get an odbc timeout. It appears to be a report setting as I can open the views independently w/o a timeout. All my SQL settings are set to zero (0) for timeouts. Any help appreciated....

  2. #2
    Join Date
    Jun 2004
    Location
    NYC Area
    Posts
    24
    To all...
    The issue is that Access has a default time-out of 90 sec's for view's linked as tables - and this time cannot be changed. The solution is to create a pass-thru calling the view and set the time-out to zero (0) instead of linking the view.
    Chris

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •