Have been using MS SQL to retrieve data from our AS/400 quite successfully. Yesterday for no apparent reason the retrieval started failing on some records with the following error message; Microsoft OLE DB Provider for SQL Server error '80040e14' [OLE/DB provider returned message: [IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]SQL0904 - Resource limit exceeded.] /qnative/order1.asp, line 149. The AS/400 information for MSGID SQL0904 shows “type 7 maximum size of prepared statement has been reached”. Can anyone advise a fix or suggest where I look next please?