After setting up an IBM i (a.k.a AS/400) as a linked server in SQL Server
using MS OLEDB Provider (V4) for DB2 ,
I get the following error with each Select statement I test.
OLE DB provider "DB2OLEDB" for linked server "AS400_PROD_OLEDB4DB2"
returned message "The maximum number of statements has been reached for the
current connection. SQLSTATE: HY000, SQLCODE: -1500".
Here's a sample SQL stmt:
select * from AS400_PROD_OLEDB4DB2.PRODDB.DCMTLIBD.STATIONF
Anyone out there familiar with this kind of error?