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?