topic Re: OLE DB not supporting TLS1.2 preventing Qlikview comms with SQL server in QlikView

OLE DB not supporting TLS1.2 preventing Qlikview comms with SQL server

seanmNL1 — Mon, 26 Jan 2026 18:19:17 GMT

Hello

I have updated OLE DB on our SQL Server to allow QlikView communicate via TLS 1.2

I believe to complete this I need to change the OLE DB connection string on the ClikView server to something like this:

Provider=MSOLEDBSQL

My question is where do I make this change? Do i make it on the Qlikview server or on the SQL Server? If it ios on the QlikView server then where on it do I make the change?

Re: OLE DB not supporting TLS1.2 preventing Qlikview comms with SQL server

Maria_Halley — Thu, 27 May 2021 08:45:22 GMT

If the connection string has changed than you would have to change it in the script.

But in general to make TLS1.2 work you don't have to do anything on the QlikView side.

Maria

Re: OLE DB not supporting TLS1.2 preventing Qlikview comms with SQL server

seanmNL1 — Thu, 27 May 2021 09:20:32 GMT

Hello Maria

Do I have to make the change within each document?

I opened one of the document and then got the option to "Edit Script"

Then under the Data tab I have OLE DB listed and can hit the "Connect" button which brings up various Providers.

Which one of these should I choose?

Attached is a screenshot of my options

Re: OLE DB not supporting TLS1.2 preventing Qlikview comms with SQL server

seanmNL1 — Fri, 28 May 2021 09:26:49 GMT

Could someone come back to me on this please?

I did choose the "MS OLE DB Provider for SQL Server" and entered config details.

The "Test Connection" worked fine.

A connection script seemed to have been created. I saved the document but then the document/task failed to reload.

Please How can we resolve this please?

Re: OLE DB not supporting TLS1.2 preventing Qlikview comms with SQL server

Lucas_Gatling — Fri, 28 May 2021 12:11:27 GMT

@seanmNL1 Can you share the document log of the QVW that is failing to reload?