AnsweredAssumed Answered

PIOLEDB timestep issue in SQL Server

Question asked by TEL1 on Apr 1, 2014
Latest reply on Dec 18, 2019 by maximedina

Hello:

 

I'm trying to do a query in SQL2008 hitting our PI server via PIOLEDB provider.

 

This query works fine, returns 25 records as expected:

SELECT tag, time, value, status

FROM [PI_LINKED].piarchive..piinterp2

WHERE tag = 'sinusoid' AND time BETWEEN '2014-03-31' AND '2014-04-01' AND timestep = '01:00:00'

 

This query does not error out, but does not return any records.

 

SELECT tag, time, value, status

FROM [PI_LINKED].piarchive..piinterp2

WHERE tag = 'sinusoid' AND time BETWEEN '2014-03-31' AND '2014-04-01' AND timestep = '00:00:01'

 

 

I'm not doing anything unusual with my connection strings when establishing a linked server.  Both queries work as expected in PISQL Commander.  picomp works fine in SQLServer2008

 

The only timestep that seems to work in SQLServer is 01:00:00.  Anything else returns 0 records.

 

Thoughts?

 

Outcomes