I'm trying to use a pass through to use iHistorian to access data I need. The code is listed at the bottom. I'm recieving the following error. ERROR: CLI describe error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot initialize the data source object of OLE DB provider "IhOLEDB.iHistorian" for linked server "fsp1". Has anyone tried this with iHistorian? Does anyone know what's going on here? ---------------------------------------------------------------- proc sql; connect to odbc as conn(dsn="FSPPDW" uid=FontaneF); create table work.Stuff as select * from connection to conn ( select * from OPENQUERY(fsp1, 'SELECT tagname, timestamp, value as Signal FROM ihrawdata WHERE timestamp > 10/23/2015 AND timestamp < 10/25/2015 AND (tagname = Fsdfeee:000) AND intervalmilliseconds = 60000 AND samplingmode=interpolated' ) ); disconnect from conn; ; quit;
... View more
