title: SAS Pass Through OpenQuery into iHistorian Error
body: <p>I am doing a pass through query using SAS into iHistorian Interactive SQL. The code is listed below. I know the pass through code works; I ran the quoted code through iHistorian Interactive SQL itself and it returned the required data. I get the following error when I attempt the provided code.</p>
  
  <p>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".</p>
  
  <p>Has anyone tried this with iHistorian? Does anyone know what's going on here? Thanks in advance.</p>
  
  <hr>
  
  <pre><code>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 &gt; 10/23/2015 AND timestamp &lt; 10/25/2015
  AND (tagname = Fsdfeee:000)
  AND intervalmilliseconds = 60000
  AND samplingmode=interpolated'
  )    
  );
  disconnect from conn;
  ;
  quit;
  </code></pre>