Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Matthias
New Contributor

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

2 Replies
Partner
Partner

Re: Connection Database

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
Support
Support

Re: Connection Database

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.