Re: DB2OLEDB update attempt

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
--