I get the following error on running a VFP6 (sp3) executable.
The program reads a dB/2 database on an IBM AS400 (The AS/400 is a CISC machine running on V3R2M0 of the OS/400) using IBM Client Access (Version level 3.1.2). I use an ADO connection in a VB6 ActiveX DLL. . The AS/400 in question is very heavily loaded and I feel that this could/may be causing the error below, but I have no ammunition with which to prove this to the customer. Initially, I thought the problem was to do with the number of licenses the customer had for query/sql/client access, but their license limits is set to *nomax, so this obviously is not the issue.
The query runs ok for less than 1000 records but the error below occurs when the number is greater than 1000.
Error: OLE IDispatch exception code 0 from dbQuery.Execute: [IBM][Client Access ODBC Driver (32-bit) ][DB2/400 SQL]SQL0904 - Resource limit exceeded…
What causes this?
Thank you all in advance