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;
Have you tried to reach it from another (non SAS ) application?
I accessed the data through iHistorian Interactive SQL and it works. I have not tried it from another software. I'm only really familar with SAS and JMP, and most of my data processing is through SAS, so I would prefer to not incorporate a 3rd software.
One obvious problem in your SAS log is that you are using SAS/ACCESS to ODBC but the database driver error references OLEDB. So what type of database driver are you using with iHistorian - OLEDB or ODBC? You can only use an ODBC driver with SAS/ACCESS to ODBC.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.