Cannot Get String Data From the ihRawData Table

The Historian OLE DB Provider, by default, does not return string data types in the ihRawData table. This is because the default SamplingMode value is Calculated. You have to change the SamplingMode value to Interpolated using the SET statement or a WHERE clause.

For example, this query does not return interpolated data:

SELECT * FROM ihRawData
WHERE tagname = simulationstring00001

However, this query does:

SELECT * FROM ihRawData
WHERE tagname = simulationstring00001 AND
samplingmode = interpolated

And so does this query:

SET samplingmode=interpolated
SELECT * FROM ihRawData
WHERE tagname = simulationstring00001