topic Re: Database Connection Failed Error with Direct Query in App Development

Database Connection Failed Error with Direct Query

greeshmak — Sat, 16 Nov 2024 00:42:00 GMT

I am creating an app in QlikSense using Direct Query. The query executes without any errors. However, when I create visuals, an error message saying 'database connection failed' shows up on the visual. I am loading only 2 dimensions and 1 measure filed. The expression for the visual is just count of the measure column.

Any idea why the error on the visuals?

Re: Database Connection Failed Error with Direct Query

JosephMorales — Wed, 03 Feb 2021 06:53:26 GMT

Hi @greeshmak

Can you tell me to which database you are performing the direct query? If it is SQL server, which connector are you using?

I was able to verify that if I use the native Qlik Sense connector for sql Server the same problem occurs to me as you have, but when using an ODBC driver for SQL I don't have the problem.

It may be a driver problem.

Regards

Joseph Morales