ygalipeau

PIODBC 2014

Discussion created by ygalipeau on Oct 24, 2014
Latest reply on Oct 27, 2014 by michaelh

good afternoon

 

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''')

 

i get

 

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".

 

 

 

thanks

 

yannick

Outcomes