https://community.qlik.com/t5/QlikView/Write-from-Qlikview-to-DB2/m-p/1643638#M732618 <P>Hello,</P><P>I'm trying to perform inse<SPAN>rtion into AS400/DB2. I've created a system DNS into ODBC Data Source Administrator with the following configuration.</SPAN></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="0.D54.gif" style="width: 536px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/22991i25B39A98261BA359/image-size/large?v=v2&amp;px=999" role="button" title="0.D54.gif" alt="0.D54.gif" /></span></P><P><SPAN>I have write permissions with my userid but when I launch the reload with QlikView the permission to write is denied, because "<EM>the connection is set to read-only"</EM>.&nbsp;</SPAN></P><P>In QlikView I've just put the settings like this but still doesn't work.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="167709_QV3 (1).jpg" style="width: 736px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/22992i6AF93DEE6722DF8D/image-size/large?v=v2&amp;px=999" role="button" title="167709_QV3 (1).jpg" alt="167709_QV3 (1).jpg" /></span></P><P>I think should be some setting of the DNS that should allow to write on db. Any suggestion?</P> Sat, 16 Nov 2024 19:44:34 GMT alessandrocroce 2024-11-16T19:44:34Z https://community.qlik.com/t5/QlikView/Write-from-Qlikview-to-DB2/m-p/1643638#M732618 <P>Hello,</P><P>I'm trying to perform inse<SPAN>rtion into AS400/DB2. I've created a system DNS into ODBC Data Source Administrator with the following configuration.</SPAN></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="0.D54.gif" style="width: 536px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/22991i25B39A98261BA359/image-size/large?v=v2&amp;px=999" role="button" title="0.D54.gif" alt="0.D54.gif" /></span></P><P><SPAN>I have write permissions with my userid but when I launch the reload with QlikView the permission to write is denied, because "<EM>the connection is set to read-only"</EM>.&nbsp;</SPAN></P><P>In QlikView I've just put the settings like this but still doesn't work.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="167709_QV3 (1).jpg" style="width: 736px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/22992i6AF93DEE6722DF8D/image-size/large?v=v2&amp;px=999" role="button" title="167709_QV3 (1).jpg" alt="167709_QV3 (1).jpg" /></span></P><P>I think should be some setting of the DNS that should allow to write on db. Any suggestion?</P> Sat, 16 Nov 2024 19:44:34 GMT https://community.qlik.com/t5/QlikView/Write-from-Qlikview-to-DB2/m-p/1643638#M732618 alessandrocroce 2024-11-16T19:44:34Z https://community.qlik.com/t5/QlikView/Write-from-Qlikview-to-DB2/m-p/1644211#M732619 <P>It seems a problem with ODBC driver configuration.</P><P>The solution is to set a OLE DB connection putting the IP address of the DB.</P> Thu, 07 Nov 2019 11:37:58 GMT https://community.qlik.com/t5/QlikView/Write-from-Qlikview-to-DB2/m-p/1644211#M732619 alessandrocroce 2019-11-07T11:37:58Z