philco

Update annotations using PI OLEDB provider

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

 

 

Hi,

 

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?

 

 

 

Thanks

 

 

 

 

Outcomes