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)

    irshad cp

      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];

       

      User_ID_to_EnteredByMap:

      Mapping LOAD

         id as user_id,

         username

      FROM  InventoryDb.Orders;