I am trying to query some alarm history from the v_AlarmHistory view in the Runtime database in Aveva Historian. This is from a software package running standard queries that are in use today on at least a few dozen systems around the world. So the queries generally work fine.
However, on a particular customer system, any query I run against the v_AlarmHistory view returns "Cannot execute the query [SELECT statement] against the OLEDB Provider INSQL for linked server "ISNQL".
This happens even running a right-click Select Top 1000 from SQL Server Management Studio. Seems like it could be something with the version of SQL OLEDB (what my software is using) or with SSMS itself (what I am using as a second client to test the database with).
Does anyone here have any ideas?
