mnadeau

Using PISDK in a SQLServer CLR Assembly

Discussion created by mnadeau on May 7, 2014
Latest reply on May 16, 2014 by Marcos Vainer Loeff

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.

 

 

Outcomes