AnsweredAssumed Answered

Unsupported RDB column type -9, PI Interface for Relational Database (RDBMS via ODBC)

Question asked by Rob-van-Ginkel-Coop on Sep 23, 2020
Latest reply on Sep 23, 2020 by cramsey

I am using a SQLServer DB to get data into the PI Archive.

This is the query:

 

Select dtStartInterrupt, diOrdNr, 0
from DBTEST.dbo.TABLE
where szWorkPlaceNa = 'test' AND dtStartInterrupt > ? ORDER BY dtStartInterrupt ASC;

 

But i get this error:

Unsupported RDB column dtStartInterrupt type -9

 

The datatype of dtStartInterrupt is Datetime2

 

Am I right in thinking the datatype should changed from Datetime2 to Datetime, in oder for the PI_RDBMS interface,3.21.4, to work?

Outcomes