Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Matthias
Contributor II
Contributor II

Connection Database

Hello !

I have a licence for Qlik Sense Enterprise. Before, I used Qlik Sense Desktop and to connect to the database, I was chosing OLE DB and was chosing "SQL Server Native Clien11.0". But in the Enterprise version, there is not this choice. Do you know which option is the same of "SQL Server Native Client 11.0" ?

Matthias

3 Replies
treysmithdev
Partner Ambassador
Partner Ambassador

I would suggest using the SQL Server connector:

clipboard_image_1.png

 

If you want to use the OLE DB, I would suggest this option:

clipboard_image_0.png

Blog: WhereClause   Twitter: @treysmithdev
Lisa_Sun
Support
Support

You can get sqlncli.msi from the SQL Server 2012 Feature Pack web page. To download the most recent version of the SQL Server Native Client, go to Microsoft® SQL Server® 2012 Feature Pack.   Details can be found from https://docs.microsoft.com/en-us/sql/relational-databases/native-client/applications/installing-sql-....

SQL Server Native Client, is a term that has been used interchangeably to refer to ODBC and OLE DB drivers for SQL Server.  But if you are using OLEDB, the better option is Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL), which will be updated with the most recent server features.

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!
luizcdepaula
Creator III
Creator III

Hi Lisa,

Thanks for your response to this post. I have been looking for a while, and the solution is simple. The providers become available once the drivers are installed in the Qlik server. People might be able to see these providers on their local computers, because they probably have some version of SQL installed, which contains the drivers. On the server, you have to install the drivers as well.

I installed client libraries for connecting to Analysis Services and OLE DB Drivers for OLE DB Driver for SQL Server, because the OLE DB Provider for SQL Server was not working for my connection. Find the links to both drivers below:

Client Libraries for Connecting to Analysis Services (Connect to SQL Cubes)

https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-data-providers

OLE DB Driver for SQL Server

https://docs.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-ser...

I hope it helps other people. 

Luiz DP