topic Re: QlikSense and ODBC With MongoDB in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/QlikSense-and-ODBC-With-MongoDB/m-p/731743#M904 <HTML><HEAD></HEAD><BODY><P>Hi Daniel,</P><P></P><P>Is the error message something that you're seeing from QlikSense or is it from the driver, do you know?</P><P></P><P>If you aren't sure, one way that you can check is to enable driver manager tracing as shown here:</P><P><A href="https://support.microsoft.com/kb/274551" title="https://support.microsoft.com/kb/274551">How To Generate an ODBC Trace with ODBC Data Source Administrator</A></P><P></P><P>Turn on tracing, restart QlikSense and retry the operation which causes the problems. Then stop tracing and open the trace log file. Somewhere near the bottom of the log there should be an entry that returns SQL_ERROR if the driver is causing the problem, if there are no errors then it is likely related to QlikSense. If there are errors, copy them into the discussion to help the analysis.</P><P></P><P>Cheers,</P><P>Kyle</P></BODY></HTML> Thu, 18 Sep 2014 21:03:57 GMT 2014-09-18T21:03:57Z QlikSense and ODBC With MongoDB https://community.qlik.com/t5/Connectivity-Data-Prep/QlikSense-and-ODBC-With-MongoDB/m-p/731742#M903 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P></P><P>I am trying to connect to MongoDB using Simba's ODBC driver and everytime I try to "save" the new ODBC connection in QlikSense, I get the following error:</P><P></P><P>An error occurred</P><P>You do not have access to a script data source</P><P></P><P>I am using a 64 bit System DSN that works perfectly with Excel, por example.</P><P></P><P>Best regards,</P><P></P><P>DAniel</P></BODY></HTML> Thu, 18 Sep 2014 13:08:38 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/QlikSense-and-ODBC-With-MongoDB/m-p/731742#M903 2014-09-18T13:08:38Z Re: QlikSense and ODBC With MongoDB https://community.qlik.com/t5/Connectivity-Data-Prep/QlikSense-and-ODBC-With-MongoDB/m-p/731743#M904 <HTML><HEAD></HEAD><BODY><P>Hi Daniel,</P><P></P><P>Is the error message something that you're seeing from QlikSense or is it from the driver, do you know?</P><P></P><P>If you aren't sure, one way that you can check is to enable driver manager tracing as shown here:</P><P><A href="https://support.microsoft.com/kb/274551" title="https://support.microsoft.com/kb/274551">How To Generate an ODBC Trace with ODBC Data Source Administrator</A></P><P></P><P>Turn on tracing, restart QlikSense and retry the operation which causes the problems. Then stop tracing and open the trace log file. Somewhere near the bottom of the log there should be an entry that returns SQL_ERROR if the driver is causing the problem, if there are no errors then it is likely related to QlikSense. If there are errors, copy them into the discussion to help the analysis.</P><P></P><P>Cheers,</P><P>Kyle</P></BODY></HTML> Thu, 18 Sep 2014 21:03:57 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/QlikSense-and-ODBC-With-MongoDB/m-p/731743#M904 2014-09-18T21:03:57Z Re: QlikSense and ODBC With MongoDB https://community.qlik.com/t5/Connectivity-Data-Prep/QlikSense-and-ODBC-With-MongoDB/m-p/731744#M905 <HTML><HEAD></HEAD><BODY><P>Thanks Kyle,</P><P></P><P>I forgot to install the SIMBA ODBC license file... it became clear in the generated ODBC trace file.</P></BODY></HTML> Thu, 18 Sep 2014 23:01:51 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/QlikSense-and-ODBC-With-MongoDB/m-p/731744#M905 2014-09-18T23:01:51Z Re: QlikSense and ODBC With MongoDB https://community.qlik.com/t5/Connectivity-Data-Prep/QlikSense-and-ODBC-With-MongoDB/m-p/731745#M906 <HTML><HEAD></HEAD><BODY><P>Hi Daniel,</P><P></P><P>Glad to help <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Cheers,</P><P>Kyle</P></BODY></HTML> Thu, 18 Sep 2014 23:03:43 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/QlikSense-and-ODBC-With-MongoDB/m-p/731745#M906 2014-09-18T23:03:43Z