Re: DB2OLEDB update attempt

[Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>]

Thanks Rob.  I wonder why Google did not show that to me.

Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On 8/21/2013 11:33 AM, rob@xxxxxxxxx wrote:
> http://support.microsoft.com/kb/2679772
>
>
>
>
> Rob Berendt
> -- IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 
> 1600 Mail to: 2505 Dekko Drive Garrett, IN 46738 Ship to: Dock 108 
> 6928N 400E Kendallville, IN 46755 http://www.dekko.com From: Jim 
> Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx> To: Midrange Systems 
> Technical Discussion <midrange-l@xxxxxxxxxxxx>, Date: 08/21/2013 12:14 
> PM Subject: DB2OLEDB update attempt Sent by: 
> midrange-l-bounces@xxxxxxxxxxxx Folks: We are trying to have MS SQL 
> server connect to IBM i DB/2 ( V5R4M5 btw ) to update several ( under 
> 30 ) rows. We get the following messages, and I can't find any 
> references to the SQLSTATE: HY0000. It takes about 30 seconds to fail 
> with the following OLE DB provider "DB2OLEDB" for linked server 
> "S10xxxxx" returned message "The maximum number of statements has been 
> reached for the current connection. SQLSTATE: HY000, SQLCODE: -1500". 
> Msg 7320, Level 16, State 2, Line 1 Cannot execute the query "select * 
> from patftp.f594063" against OLE DB provider "DB2OLEDB" for linked 
> server "S10xxxxx". updatej set j.qzfy = 14 from openquery(S100BB2M, 
> 'select * from patftp.f594063') j where j.qz$wsa = 2604378 Any ideas?
> -- Jim Oberholtzer Chief Technical Architect Agile Technology Architects
> --