Error executing Stored Procedure from VS.Net 2005

Hi, there. I have a VS.Net 2005 (Framework.Net 2.0) application using the OLE DB
Provider for iSeries and when it executes a stored procedure that returns more
than, say, a hundred records I continue getting this error:<br />
<br />
<i>ERROR <a
href="http://www-128.ibm.com/developerworks/forums/">08001</a>
; <a
href="http://www-128.ibm.com/developerworks/forums/">IBM</a>&
lt;a
href="http://www-128.ibm.com/developerworks/forums/">AS</a>
SQL30081N  A communication error has been detected.  Communication protocol
being used: "TCP/IP".  Communication API being used:
"SOCKETS".  Location where the error was detected:
"10.100.3.15".  Communication function detecting the error:
"recv".  Protocol specific error code(s): "<b>",
"</b>", "0".  SQLSTATE=08001</i><br />
<br />
<i>ERROR <a
href="http://www-128.ibm.com/developerworks/forums/">58005</a>
; <a
href="http://www-128.ibm.com/developerworks/forums/">IBM</a>&
lt;a
href="http://www-128.ibm.com/developerworks/forums/">AS</a>
SQL0902C  A system error (reason code = "18") occurred.  Subsequent
SQL statements cannot be processed.  SQLSTATE=58005</i><br />
<br />
This problem does not state when the SP returns only a few records to the
client. Also, we built some test applications using ODBC and other connectors
and the SP behaves well.<br />
<br />
We have DB2 V5R4.<br />
<br />
Any help to go around this error would be greatly appreciated.<br />
<br />
Thanks in advance.<br />
<br />

try using IBM.Data.DB2.iSeries.iDB2Connection instead of OLE DB for the
connection<br />
<br />

From your message description, it sounds like you are using not the System i
Access for Windows product, but the DB2 Connect product.  If that is the case,
you will have better luck at the 'DB2 UDB with .NET' forum:<br />