I'm developing a VB ASP.NET application, accessing IBM (mainframe) DB2 stored procedure (external function type). I'm using ADO OleDbDataReader to call the stored procedure. I'm running into a problem where if the number of records returned is more than 200 it gives the error below:
[DB2] SQL30000N Execution failed because of a Distributed Protocol Error that will not affect the successful execution of subsequent commands or SQL statements: Reason Code "220E"(""). SQLSTATE=58008
I used the same code to run against Sybase database, I'm able to return more than 2000 records. Any suggestion is greatly appreciated. Thanks.