0 Replies Latest reply: Jun 22, 2013 9:20 AM by abdelmalek khettouf RSS

    Problem executing a loading script on QV

    abdelmalek khettouf

      Hello everyone,

       

      I'm developing a little Qlikview application, and since one hour I'm trying to load some data from an MS Access database, but I obtain an error I can't Resolve, can anyone help?

       

      SET ThousandSep=' ';
      SET DecimalSep=',';
      SET MoneyThousandSep=' ';
      SET MoneyDecimalSep=',';
      SET MoneyFormat='# ##0,00 €;-# ##0,00 €';
      SET TimeFormat='hh:mm:ss';
      SET DateFormat='DD/MM/YYYY';
      SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
      SET MonthNames='janv.;févr.;mars;avr.;mai;juin;juil.;août;sept.;oct.;nov.;déc.';
      SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.';
      
      
      ODBC CONNECT32 TO [TR_CLUB;DBQ=C:\Users\Toshiba\Desktop\TR_CLUB.mdb];
      
      
      SQL SELECT *
      FROM Sales
      INNER JOIN Invoice_Line on Sales.inv_id = Invoice_Line.inv_id
      ;
      

       

      And the error is :

       

      Échec de lecture ODBC
      SQL SELECT *
      FROM Sales
      INNER JOIN Invoice_Line on Sales.inv_id = Invoice_Line.inv_id