LIB CONNECT TO in Read/Write mode

[AM2]

Hi,

in qlikview i have

ODBC CONNECT TO Vertica (XUserId is QeLRRWFMObYSGXFNWD, XPassword is ETZBFYAHRRMADYUNAScA,mode is write);

SQL
CREATE LOCAL TEMP TABLE temp_table1 ON COMMIT PRESERVE ROWS
as .......

How to Replay the Read/Write function in Qlik Sense LIB CONNECT TO  ?

[mpc]

Hi, 

By using the Lib Connect To, the settings used is the one configured in the ODBC driver. 
Then, in my memories, the ODBC driver has a "read-only" option to uncheck.

You can check if the account used to query the Database has write privilege too. 

And then you can execute a query like that: 
SQL:
Insert into myTable values ('A','B','C'); 

Kind regards 

[AM2]

Hi, tanks.

ODBC has already "read-only" unchecked

DB Vertica schema xxxxxxxxxx has write privilege.

Error is not possible in transaction in read only mode.