Unable to do data connection with MS SQL SERVER DB

[suvechha_b]

Hi All ,

I am getting error message when trying to load a qliksense app fetching data from Microsoft SQL Server in QMC  Tasks

getting error log -

2019-04-17 05:29:49 0023 LIB CONNECT TO 'CDW_ODBC_PROD'
2019-04-17 05:29:49 Error: Connector connect error: ErrorSource: Unknown source, ErrorMsg: Unknown description
2019-04-17 05:29:49 Execution Failed
2019-04-17 05:29:49 Execution finished.

Please kindly assist. How to set up the data connection properly. My Database is Microsoft SQL server. 

Thanks in Advance.

[suvechha_b · Accepted solution]

Hi ,

The solution I found was I had to install the ODBC Driver for MS SQL Server in the Qliksense Server. 

Config the System DSN correctly like below.

Then , I used the Microsoft OLEDB Connection for ODBC Driver (32 bit).