topic Re: Pass Through iHistorian SQL Error in SAS Procedures

Pass Through iHistorian SQL Error

alewis3663 — Thu, 12 Nov 2015 21:31:19 GMT

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;

Re: Pass Through iHistorian SQL Error

LinusH — Fri, 13 Nov 2015 13:04:35 GMT

Have you tried to reach it from another (non SAS ) application?

Re: Pass Through iHistorian SQL Error

alewis3663 — Fri, 13 Nov 2015 14:24:20 GMT

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.

Re: Pass Through iHistorian SQL Error

LinusH — Sat, 14 Nov 2015 10:04:43 GMT

You should for trouble shooting purposes. Just try to open your source in Excel or any other OLE db/odbc client.

Re: Pass Through iHistorian SQL Error

SASKiwi — Sun, 15 Nov 2015 18:30:46 GMT

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.