Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master III
Master 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
Creator II
Creator II

Re: Direct Disovery QVW showing Database  Connection Failed in AccessPoint

Yes. connection Succeeded.

Highlighted
Master III
Master III

Re: Direct Disovery QVW showing Database Connection Failed in AccessPoint

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

Highlighted
Creator II
Creator 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
Creator II
Creator 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
Master III
Master III

Re: Direct Disovery QVW showing Database Connection Failed in AccessPoint

Try

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

Highlighted
Creator II
Creator II

Re: Direct Disovery QVW showing Database  Connection Failed in AccessPoint

Hi,

not working..

Highlighted
Creator II
Creator II

Re: Direct Disovery QVW showing Database Connection Failed in AccessPoint

even without where condition also not working...

Highlighted
Master III
Master 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