Some useful SQL for OLEDB
Get snapshot for all tags
SELECT tag, time, value, DIGSTRING(status) AS status FROM piarchive..pisnapshot
Get data for a digital tag
SELECT tag, time, DIGSTRING(CAST(value AS Int32)) AS value, DIGSTRING(status) AS status
FROM piarchive..picomp2
WHERE tag = 'cdm158' AND time >= 't'
FROM piarchive..picomp2
WHERE tag = 'cdm158' AND time >= 't'
