I created a class library in .Net to allow me to interface with PI in realtime in SQL Server.
I have resgistered it as an assembly in SQL Server and created my Stored Procedure (which uses the assembly) to execute.
My routine to insert values into PI for a tag is working properly. My routine to get the value of a PI tag is not working. I put in some debug messages into my class library to pinpoint where the problem is. It is on this line of code. :
dblTagResult = pv.Value (pv is of type PISDK.PIValue)
I get the error message -> Dynamic operations can only be performed in homogenous AppDomain.
I wrote a wrapper windows form to also execute my class library and it is working fine. Its only when I introduce SQL Server I have the issue.
Thanks in advance for your assistance.