topic Re: Qlik Sense Connecting to OLE DB Error (Connector Connect Error: {0} in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Sense-Connecting-to-OLE-DB-Error-Connector-Connect-Error-0/m-p/88355#M453 <HTML><HEAD></HEAD><BODY><P>Fixed by changing from Windows Auth to SQL Auth in SQL Management Studio and using downloaded MS SQL Native Driver.</P></BODY></HTML> Thu, 28 Jun 2018 09:23:43 GMT bwisealiahmad 2018-06-28T09:23:43Z Qlik Sense Connecting to OLE DB Error (Connector Connect Error: {0} https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Sense-Connecting-to-OLE-DB-Error-Connector-Connect-Error-0/m-p/88354#M452 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Been running into this pesky error lately and can't seem to understand what it is that is doing it.</P><P></P><P>When I try to create a OLE DB connection I get this error: Connector connect error: {0}.</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/206474_Capture.PNG" style="height: auto;" /></P><P></P><P>I've tried to look it up at the forum, but haven't found any solutions that worked.</P><P></P><P>Thanks!</P><P></P><P>// Ali A</P></BODY></HTML> Thu, 28 Jun 2018 08:46:43 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Sense-Connecting-to-OLE-DB-Error-Connector-Connect-Error-0/m-p/88354#M452 bwisealiahmad 2018-06-28T08:46:43Z Re: Qlik Sense Connecting to OLE DB Error (Connector Connect Error: {0} https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Sense-Connecting-to-OLE-DB-Error-Connector-Connect-Error-0/m-p/88355#M453 <HTML><HEAD></HEAD><BODY><P>Fixed by changing from Windows Auth to SQL Auth in SQL Management Studio and using downloaded MS SQL Native Driver.</P></BODY></HTML> Thu, 28 Jun 2018 09:23:43 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Sense-Connecting-to-OLE-DB-Error-Connector-Connect-Error-0/m-p/88355#M453 bwisealiahmad 2018-06-28T09:23:43Z