Direct Discovery - Database connection failed after reopen .qvw

[Anonymous]

Hello, can someone help about this issue? I've searched on another community link and still no result.

This is my script:

ODBC CONNECT32 TO [Direct Discovery;DBQ=C:\Users\...\Desktop\Database11.accdb];

Table1:

DIRECT QUERY

DIMENSION

ID,

Name,

Age

MEASURE

HasMoney

FROM "C:\Users\...\Desktop\Database11.accdb"."User2";

After i wrote the script, i reload and it show no error, after that i close my QVW and reopen my QVW and goes like this

For chart, i use straight table and using Sum(HasMoney).

Please help,

Thankyou,

Hartanto

[sebastianoe]

Did you ever find a solution for this issue? i struggle with the same thing.