Just wondering if someone else had this issue:
I use the last PI-OLEDB with PI-SDK 126.96.36.1997.
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.