topic Re: ApplicationIntent=ReadOnly in QlikView

ApplicationIntent=ReadOnly

vvvvvvizard — Wed, 10 Feb 2021 12:12:21 GMT

i have a oledb connection to a database in qlik sense , i was asked to make sure i add

ApplicationIntent=ReadOnly; to the connection string so i dont connect to the primary db

How do i even view the connection string in Qlik sense

Where do i add ApplicationIntent=ReadOnly

vvvvvvizard — Sun, 14 Feb 2021 10:30:12 GMT

vvvvvvizard — Thu, 11 Mar 2021 07:14:27 GMT

Does anyone know ?

vvvvvvizard — Thu, 11 Mar 2021 07:44:51 GMT

You can in the QMC under data connection

RenukaSasikumar15 — Thu, 17 Oct 2024 11:26:29 GMT

Even after adding "ApplicationIntent=ReadOnly" to the data connection, it still connects to the primary database instead of the ReadOnly node.

Any solution to it?