This works in PI OLE DB version 220.127.116.11. After upgrading to PI OLE DB version 18.104.22.168, I am unable to execute the following query when accessing the PI linked server from SQL Server 2012 SP3:
DECLARE @piTag nvarchar(250) = 'sinusoid' EXECUTE(N' SELECT (?) as tag' , @piTag ) AT PISERVER
This query is a "watered down" version of what I'm trying to do. I tested with a DATETIME2 parameter and that worked, but varchar/nvarchar parameters do not. I was able to narrow the error to this as the cause. I just receive the following error now:
This is the result on PI OLE DB version 22.214.171.124:
Is this a known issue or is there a workaround?