5 Replies Latest reply: Mar 20, 2016 7:40 AM by Stefan Wühl RSS

    How could we use Mapping LOAD from MySQL(ODBC Connection)

      When i connect to Mysql DB from Qlikview (using ODBC 32) it works fine, But when i use Mapping LOAD from Mysql Table it shows


      Cannot Open file  filepath\InventoryDb.Orders System Can't find the file specified error generate. Actually there is no such location like filepath\ InventoryDb.Orders. Qlikview wrongly assuming my MySQL table as file.What i do to resolve this.



      My Script is like this:


      ODBC CONNECT TO InventoryDSN; //DSN i used to connect MySQL DB


      Also i tried OEDB Provider for ODBC


      OLEDB CONNECT32 TO [Provider=MSDASQL.1;Persist Security Info=False;Data Source=InventoryDSN;Extended Properties="DSN=InventoryDSN;";Initial Catalog=InventoryDb];



      Mapping LOAD

         id as user_id,


      FROM  InventoryDb.Orders;