AnsweredAssumed Answered

Error in OLEBBENT

Question asked by larsoleruben on Feb 15, 2016
Latest reply on Feb 17, 2016 by larsoleruben

We are using OLEDBENT as link to a SQLServer 2012. Sometimes one of the clients using thi view gets the following error:

 

OLE DB provider "PIOLEDBENT" for linked
server "CSI00810_AF_LINKED" returned message "[PI SDK] Class not
registered".

Msg 7320, Level 16, State 2, Line 1

Cannot execute the query "SELECT
"Tbl1002"."Element"
"Col1005","Tbl1002"."Attribute"
"Col1006","Tbl1002"."Tag"
"Col1007","Tbl1002"."Value"
"Col1008","Tbl1002"."Status"
"Col1009","Tbl1002"."Annotated"
"Col1010","Tbl1002"."IsGood"
"Col1011","Tbl1002"."Questionable"
"Col1012","Tbl1002"."Substituted"
"Col1003" FROM
"DongEnergyWind"."Data"."QuorumEDL"
"Tbl1002"" against OLE DB provider "PIOLEDBENT" for
linked server "CSI00810_AF_LINKED".

 

I never ever get the error from SQL-Studio. But is seems the error goes away for the other client, the moment I make a connection and use the same select from SQL-Server Management Studio.

Outcomes