Direct Disovery QVW showing Database Connection Failed in AccessPoint

[balasundaram]

Hi,

  In QV desktop level, Direct discovery qvw working properly, But in Accesspoint its show data connection failed.

while reloading in QMC , there is no issues.

How to solve this issue?

any one can u suggest ?

Regards,

Bala

[antoniotiman]

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

[balasundaram]

Yes. connection Succeeded.

[antoniotiman]

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

[balasundaram]

Hi,

DIRECT QUERY

   DIMENSION

Account_Id

measure

Billing_Amount

detail

Order_Date,

Status_Name

FROM $(vSchemaName).$(vTableName)

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

[balasundaram]

HI Avinash,

can u give any suggestions?

[avinashelite]

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

[antoniotiman]

Try

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

[balasundaram]

Hi,

not working..

[balasundaram]

even without where condition also not working...

[antoniotiman]

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