topic Troubles connecting to SAS in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Troubles-connecting-to-SAS/m-p/1200573#M2206 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>We have some troubles connecting to SAS and hopefully someone could advise.</P><P>We've been trying to connect to SAS 9.3 via OLEDB and ODBC connection.</P><P>We managed to create connection via OLEDB using SAS IOM Data Provider 9.2 (32bit) and <SPAN style="font-size: 13.3333px;">SAS IOM Data Provider 9.4 however we did not manage to load any data (QlikView stopped working and did not even insert connection string and Qlik Sense did not preview any data so we could not select anything to load).</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Has anyone experienced similar issue ? Any ideas what could be the problem and how to fix it ?</SPAN></P><P></P><P>Thanks a lot</P><P>K.</P></BODY></HTML> Mon, 17 Oct 2016 11:04:41 GMT Anonymous 2016-10-17T11:04:41Z Troubles connecting to SAS https://community.qlik.com/t5/Connectivity-Data-Prep/Troubles-connecting-to-SAS/m-p/1200573#M2206 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>We have some troubles connecting to SAS and hopefully someone could advise.</P><P>We've been trying to connect to SAS 9.3 via OLEDB and ODBC connection.</P><P>We managed to create connection via OLEDB using SAS IOM Data Provider 9.2 (32bit) and <SPAN style="font-size: 13.3333px;">SAS IOM Data Provider 9.4 however we did not manage to load any data (QlikView stopped working and did not even insert connection string and Qlik Sense did not preview any data so we could not select anything to load).</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Has anyone experienced similar issue ? Any ideas what could be the problem and how to fix it ?</SPAN></P><P></P><P>Thanks a lot</P><P>K.</P></BODY></HTML> Mon, 17 Oct 2016 11:04:41 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Troubles-connecting-to-SAS/m-p/1200573#M2206 Anonymous 2016-10-17T11:04:41Z Re: Troubles connecting to SAS https://community.qlik.com/t5/Connectivity-Data-Prep/Troubles-connecting-to-SAS/m-p/1200574#M2207 <HTML><HEAD></HEAD><BODY><P>I suggest you read the SAS documentation concerning their providers: <A href="http://support.sas.com/documentation/tools/oledb/gs_about_prov.htm" title="http://support.sas.com/documentation/tools/oledb/gs_about_prov.htm">About the SAS Data Providers</A></P><P>Make sure all the needed SAS components, like servers / services, are installed and configured correctly: <A href="https://support.sas.com/documentation/tools/oledb/gs_testing.htm" title="https://support.sas.com/documentation/tools/oledb/gs_testing.htm">Testing SAS Data Provider Installation</A></P></BODY></HTML> Tue, 18 Oct 2016 10:23:12 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Troubles-connecting-to-SAS/m-p/1200574#M2207 Gysbert_Wassenaar 2016-10-18T10:23:12Z