Our organization has recently upgraded to Office 2016 and as part of that we are now using PIODBC 2016 R2 vs. our old version of the driver (126.96.36.199). I used to be able to pass an SQL query that that looked like this to the PI Server:
SELECT time FROM piinterp WHERE time='*-1.5d' and tag='sinusoid'
PIODBC now gives me a conversion error. If I change the time specification so that it uses only integer values, the query works fine and returns a value. Does anyone have any ideas about how to get around this? I am hoping to avoid doing something like specifying everything in minutes to get the time resolution necessary.