is an a PI ODBC 2014 DSN can be use in a SQL Linked Server with the OLDB Privider for ODBC Driver like the early PI ODBC few years ago?
I configured one, the test connection succeed, but when doing a simple query like
select * from openquery(PIODBC_ITWKS14
,'select * from pipoint where tag = ''sinusoid''')
Msg 7399, Level 16, State 1, Line 2
The OLE DB provider "MSDASQL" for linked server "PIODBC_ITWKS14" reported an error. The provider reported an unexpected catastrophic failure.
Msg 7330, Level 16, State 2, Line 2
Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "PIODBC_ITWKS14".