topic Re: Add providers to OLE DB Providers list in Connectivity & Data Prep

Add providers to OLE DB Providers list

jananireddy1 — Thu, 23 Dec 2021 15:22:59 GMT

Hello,

While we were in the middle of trying to connect to a data source, I was wondering if there is anyway we can add more providers to this list here below.

Right now i have installed an OLE DB driver (SQL Native Client 11.0 and 17.0 versions https://www.microsoft.com/en-us/download/details.aspx?id=36434) and they don't show here. What is it that it takes to add to these providers

Thanks,

Janani

Re: Add providers to OLE DB Providers list

Databayo — Tue, 31 Jan 2023 00:52:16 GMT

Also interested in the answer to this.

Re: Add providers to OLE DB Providers list

Jay_Brown — Tue, 31 Jan 2023 13:20:51 GMT

Hello @jananireddy1 and @Databayo ,

OLE DB drivers need to be installed at the OS level based on need if they don't ship with your version of Windows. If you install the OLE DB Driver in Windows, it should automatically show up within Qlik Sense.

Note: that for multi-node environments the OLE DB driver must be installed on all rim nodes, so if you are multi-node be sure to remember this.