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