Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I would suggest using the SQL Server connector:
If you want to use the OLE DB, I would suggest this option:
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.
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
I hope it helps other people.
Luiz DP