Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

Unable to do data connection with MS SQL SERVER DB

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.

 

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

1 Reply
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