Write from Qlikview to DB2?

[alessandrocroce]

Hello,

I'm trying to perform insertion into AS400/DB2. I've created a system DNS into ODBC Data Source Administrator with the following configuration.

I have write permissions with my userid but when I launch the reload with QlikView the permission to write is denied, because "the connection is set to read-only". 

In QlikView I've just put the settings like this but still doesn't work.

I think should be some setting of the DNS that should allow to write on db. Any suggestion?

[alessandrocroce · Accepted solution]

It seems a problem with ODBC driver configuration.

The solution is to set a OLE DB connection putting the IP address of the DB.