Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Have you try this
Direct Discovery with MS SQL Views - Direct query failed
what's the error your getting??
Does the QVserver user account has the access for the DB....If its working in QMC it should ideally work.
error- Database connection failed.
if u tried then only u can understand.
Regards,
Bala
I am implemented...I have not faced such issue
In Access point u didn't get any issue like below image?
Regards
Bala
Hi Bala,
It hard to tell what could be the issue, check for the below set of points once:
1.Check whether your qlikview service account has access for the DB.
2.Check the server ODBC connection ..i.e in local you might have created 64 bit in the server it might be 32 bit
3.According to the DB few connection needed to be done..e.g for MYSQL you need to
SET DirectIdentifierQuoteChar='``';
and which version of Qlikview your using ..its supported after 11.2.0
Hi Avinash,
I am using QV 11.2 SR11.
I am conecting to Vertica DB.
In My system its working fine. Even In Dev system, by using QMC i can able to reload.
while opening in Accesspoint, i am getting error.
the commection to HP Vertica is via ODBC??
Yes