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