Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Honored Contributor III

Re: Direct Disovery QVW showing Database Connection Failed in AccessPoint

Have You tried to test Connection via ODBC Data Source Configuration on the Server ?

Highlighted
Contributor II

Re: Direct Disovery QVW showing Database  Connection Failed in AccessPoint

Yes. connection Succeeded.

Highlighted
Honored Contributor III

Re: Direct Disovery QVW showing Database Connection Failed in AccessPoint

Can You attach piece of script (lines of Direct Query) ?

Highlighted
Contributor II

Re: Direct Disovery QVW showing Database Connection Failed in AccessPoint

Hi,

DIRECT QUERY

   DIMENSION

  

   

Account_Id

measure

Billing_Amount

detail

Order_Date,

Status_Name

FROM $(vSchemaName).$(vTableName)

where Document_Type in ('N','S') ;

Highlighted
Contributor II

Re: Direct Disovery QVW showing Database Connection Failed in AccessPoint

HI Avinash,

can u give any suggestions?

Highlighted

Re: Direct Disovery QVW showing Database Connection Failed in AccessPoint

try without the where condition once because it have some issues with the syntax.  and also try with the forced ODBC32 bit

Highlighted
Honored Contributor III

Re: Direct Disovery QVW showing Database Connection Failed in AccessPoint

Try

Native('where Document_Type in ('N','S')');

Highlighted
Contributor II

Re: Direct Disovery QVW showing Database  Connection Failed in AccessPoint

Hi,

not working..

Highlighted
Contributor II

Re: Direct Disovery QVW showing Database Connection Failed in AccessPoint

even without where condition also not working...

Highlighted
Honored Contributor III

Re: Direct Disovery QVW showing Database Connection Failed in AccessPoint

If You have any System Monitor of Query, You can see what QV sends to DB.

Or You can activate LOG Query directly in ODBC Data Source