Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us March 10th, 7 ways modern analytics can help you take smarter action. REGISTER NOW
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

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

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