topic Re: SQL Server Native Client on Qlik Sense Server in App Development

SQL Server Native Client on Qlik Sense Server

rodrigue_saade — Tue, 10 Nov 2015 14:38:41 GMT

Dears,

how can i get the connector "SQL Server Native Client 11.0" on Qlik Sense Server?? It is available on Qlik Sense Desktop version, but i need it in the QLik Sense Server version, how to get it?

Re: SQL Server Native Client on Qlik Sense Server

Gysbert_Wassenaar — Wed, 11 Nov 2015 06:43:24 GMT

Install that OLEDB driver on the server machine where you installed Qlik Sense Server.

Re: SQL Server Native Client on Qlik Sense Server

Chanty4u — Wed, 11 Nov 2015 08:10:42 GMT

as suggested gysbert. u can install where qliksense server is availble...may be windows it is not supporting server version i thnk..

Thanks

Suresh

Re: SQL Server Native Client on Qlik Sense Server

JonnyPoole — Wed, 11 Nov 2015 14:01:36 GMT

If you install the ODBC Connector package v1.0 from Qlik , 'SQL Server' will show up in the connector list. This is in addition to ODBC/OLDEB options which are always available but require you to install said drivers and setup connections before hand

here are more details. install the package on the server where Sense is running

http://help.qlik.com/Connectors/en-us/connectors/#../Subsystems/ODBC_connector_help/Content/1.0/Install-ODBC-connector.h…

Not every server environment wants to install qlik's connectors (some people want to manage the drivers independently) but the option is there.

Re: SQL Server Native Client on Qlik Sense Server

rodrigue_saade — Tue, 24 Nov 2015 13:19:03 GMT

Hi all,

Thank you for your replies, but actually i solved it by installing the SQL Native Client driver on the server.

The installer was downloaded from Microsoft website.

Note that it is a part of the SQL Server installation, so if you install SQL Server on a PC, you will get the Native Client automatically.

Regards.