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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.