Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Problem executing a loading script on QV

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

Tags (2)
Community Browser