3 Replies Latest reply: Sep 30, 2017 10:47 PM by Nur Faten Munirah Mahfudz RSS

    Qlik Sense ODBC UDC error

    Aravind Sasidharan



      I am using the load script to generate the users and user attributes in the format that Server needs.


      so in the load script I do the ETL and use


      Store user_attributes into  [C:\<path>\user_attributes.csv] (txt, delimiter is ',');


      Now this CSV is UTF-8 encoded. As suggested here




      If I try to setup a UDC using ODBC


      Driver={Microsoft Access Text Driver (*.txt, *.csv)};Extensions=asc,csv,tab,txt;DefaultDir=C:\<path>


      I get an error saying cannot read userid from the table.


      Manually created CSV in ansi format works fine.


      Is it possible to force QLik to use ansi encoding while storing CSV files? Or is there any other way to change the driver parms to UTF-8 encoded CSV.