Query Linked PI Server

Discussion created by EndEng on Oct 8, 2010
Latest reply on Mar 18, 2011 by spilon

I have SQLServer linked to my PI database using oleDB classic.  In Management Studio i can expand the PI catalogs, however i am unable to extract any data.


when i run select * from pi.pipoint..classic the query manager goes out into space and runs forever, i can't cancel or do anything with it.  PI is the name of my linked server. 


To the best of my knowledge the Linked server is configured via the white paper.