topic ODBC Issues in QlikView

ODBC Issues

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

We're having trouble getting Qlik to work correctly with an ODBC connection. We've created an ODBC connection to use a specific AD account to connect to a SQL DB. However when Qlik runs the ODBC connection it runs it with the account running the Qlik service and not the one specified with the ODBC management tool. Any ideas?

Re: ODBC Issues

sasiparupudi1 — Fri, 27 Apr 2018 05:49:45 GMT

May be add the odbc user as a qlik user in qmc

Re: ODBC Issues

awhitfield — Fri, 27 Apr 2018 10:26:59 GMT

Hi Jason,

has you specified the user name and password in the ODBC connection string:

ODBC CONNECT TO DSNNAME (UserId is xxx, Password is xxx);

Andy