Direct Discovery - Database connection failed after reopen .qvw

Anonymous — Tue, 19 Dec 2017 09:47:41 GMT

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

Re: Direct Discovery - Database connection failed after reopen .qvw

sebastianoe — Thu, 03 Mar 2022 12:36:21 GMT

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