SQL - Server & PI - OLEDB Hanging after 60seconds of no query

Discussion created by wpurrer on May 25, 2010
Latest reply on Mar 18, 2011 by spilon



Just wondering if someone else had this issue:


I use the last PI-OLEDB with PI-SDK


The PI-SDK has the known issue (PLI 22196OSI8) where the consequence is, that the pi oledb hangs if there is for more then 60 seconds no query if it is used as a linked Server in the SQL - Server.


Workaround (SPTimeout set to a very high number).


Wolfgang (no diving in the deepth of PI - OLEDB ... a couple of support requests pending.... ;-) )


UPDATE: this is a known issue indeed. Find more details in this discussion thread.