<div>
You pointed me in the right direction<br />

</div>


<div>
<div class="content wysiwyg-content">
I get the following error on running a Visual FoxPro 6.0(sp3) executable.<br />
The program reads a DB/2 database on an IBM AS400 using IBM Client Access. I use an ADO connection in a VB6 ActiveX DLL.<br />
The query runs ok for less than 1000 records but the error below occurs when the number is greater than 1000.<br />
<br />
Error: OLE IDispatch exception code 0 from dbQuery.Execute: [IBM][Client Access ODBC Driver (32-bit) ][DB2/400 SQL]SQL0904 – Resource limit exceeded…<br />
<br />
<br />
What causes this?<br />
Thank you all in advance<br />
Denis<br />

</div>
</div>


I get the following error on running a Visual FoxPro 6.0(sp3) executable.
The program reads a DB/2 database on an IBM AS400 using IBM Client Access. I use an ADO connection in a VB6 ActiveX DLL.
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
Denis


Resource limit exceeded

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.