Microsoft OLE Provider for ODBC Drivers not working in Qliksense Server.

[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.

The data connection is working fine in Qliksense Desktop . The OLEDB Connection is set up using Microsoft OLEDB Provider for ODBC Drivers. Please see images attached.

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. 

Step1

Thanks in Advance.

[jonathandienst]

If you are connecting using a DSN, use the straight ODBC driver and not the driver you selected.

[suvechha_b]

Hi      jontydkpi ,

Please kindly explain step by step as I am new to the set up things. Many Thanks

[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).