Update annotations using PI OLEDB provider

Discussion created by philco on Nov 14, 2013
Latest reply on Nov 19, 2013 by Gregor





I'm trying to create and/or update annotations using the PI OLEDB provider with no success. Is this something that is feasible? Reading the documentation I thought it was but I'm not so sure now.




Here's my query:


commandPI =New SqlCommand("UPDATE OPENQUERY ( PI, 'SELECT tag, time, annotations " & _


"FROM piarchive..picomp2 " & _


"WHERE tag = ''" & mytag & "'' " & _


"AND time = ''" & mytime & "''') " & _


"SET annotations = '" & myannotation & "'", connPI)




And here's the error message:


“UpdateAnnotation error: OLE DB provider 'PIOLEDB' reported an error. The provider does not support the necessary method. OLE DB error trace [OLE/DB Provider 'PIOLEDB' IRowsetChange::SetData returned 0x80040e53: The provider does not support the necessary method.].




It is a simple unstructured string annotation. I’m using the PI OLEDB Provider 2010 R3.


I know I can use PI SDK but that’s for a new feature that goes in an existing form that already uses PI OLEDB. Any Ideas?