topic Re: Unable connect to ODBC data connection in Connectivity & Data Prep

Unable connect to ODBC data connection

peggypoon — Wed, 23 Jan 2019 01:59:35 GMT

I have created a ODBC data connection on the apps and execute the apps to get data on QlikSense desktop platform without problem.
However, we are unable connect to SQL db through ODBC connection in real production environment.
We have published the qlik sense apps to production server.

Any idea about this scenario? Any work around solution?

Thank you.

Re: Unable connect to ODBC data connection

peggypoon — Wed, 23 Jan 2019 02:05:18 GMT

Please refer to attached log file. Thank you.

Re: Unable connect to ODBC data connection

crusader_ — Wed, 23 Jan 2019 03:00:51 GMT

For better understanding of the issue you need to check Qlik Sense Server log files.

Anyway before moving forward make sure:

- your DB is accessible from QS Scheduler servers (slaves only for multi-node cluster), e.g. firewall with respective port is opened between QS Scheduler and DB instances;

- if you're using ODBC connection, it needs to be created on all slave QS Scheduler machines;

- Connection exist on QS server and service account has a "read" permission to it;

Continue narrowing down the issue to find out the root cause.

Hope this helps!

//Andrei