Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

Data Connection not working in qliksense server.

Hi All ,

I did data connection wth Qliksense Desktop with MS SQL SERVER like below images and it work well.

But when I publish my Apps to Qliksense Server through QMC, the data connection is not working.

 

Step1.PNG

I did configure the ODBC Data Source Administrator set up in Qliksense Server

But the data connection is not working. Please kindly assist.

1 Solution

Accepted Solutions
suvechha_b
Creator III
Creator III
Author

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.

Config.PNG

 

 

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

ODBC.PNG

View solution in original post

2 Replies
Channa
Specialist III
Specialist III

USE OLEDB PROVIDER FOR SQL SERVER

 

WHY YOU ARE USING ODBC..

Channa
suvechha_b
Creator III
Creator III
Author

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.

Config.PNG

 

 

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

ODBC.PNG