https://communities.sas.com/t5/SAS-Programming/Connecting-to-a-InterSystems-Cache-ODBC-Data-source/m-p/300275#M312259 <P>The first&nbsp;step is to make sure that the ODBC driver and connection works outside SAS, like calling it from Excel.</P> <P>&nbsp;</P> <P>Then, if your libname stills fails, please share the code/full log.</P> Fri, 23 Sep 2016 03:37:28 GMT LinusH 2016-09-23T03:37:28Z https://communities.sas.com/t5/SAS-Programming/Connecting-to-a-InterSystems-Cache-ODBC-Data-source/m-p/300153#M312258 <P>Hi,</P> <P>&nbsp;</P> <P>I have an oracle database that has been set up using InterSystems Cache driver in the ODBC window. I am wondering if anyone knows how I can specify a libname to set this up. I used OBC but it says that</P> <P>&nbsp;</P> <P>ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] The specified<BR /> DSN contains an architecture mismatch between the Driver and Application<BR />&nbsp;</P> <P>Thanks.</P> Thu, 22 Sep 2016 16:34:10 GMT https://communities.sas.com/t5/SAS-Programming/Connecting-to-a-InterSystems-Cache-ODBC-Data-source/m-p/300153#M312258 lei 2016-09-22T16:34:10Z https://communities.sas.com/t5/SAS-Programming/Connecting-to-a-InterSystems-Cache-ODBC-Data-source/m-p/300275#M312259 <P>The first&nbsp;step is to make sure that the ODBC driver and connection works outside SAS, like calling it from Excel.</P> <P>&nbsp;</P> <P>Then, if your libname stills fails, please share the code/full log.</P> Fri, 23 Sep 2016 03:37:28 GMT https://communities.sas.com/t5/SAS-Programming/Connecting-to-a-InterSystems-Cache-ODBC-Data-source/m-p/300275#M312259 LinusH 2016-09-23T03:37:28Z