SQL ERROR 666 using client access driver with Microsoft Access query


  • I keep getting ODBC-Call Failed error

    [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0666 - SQL query exceeds specified time limit or storage limit.

    Query is From Microsoft Access to an AS400 database using iSeries ODBC connection.

    I have set the QueryTimeout to 0 in the registry; unchecked allow query timeout in ODBC connection, and set the ODBC Timeout in the query design to zero. Still unable to run query because of the SQL error. Is there anywhere else to change the time limit, or the storage limit. This seems to be a recurring issue with numerous access queries

    lunedì 22 agosto 2011 15:00


  • Since this is an IBM product, you may want to post this question on IBM forum or contact the IBM customer support for help. I believe they can help you much better than us.


    WDAC Team, Microsoft.


    Pak-Ming Cheung - MSFT
    venerdì 30 settembre 2011 01:08