Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i have assigned one connection string to variable, i am using that variable in qlikview.
when im running qlikview script im not able to connect to the Oracle database.
without using variable im able to connecto to the database.
kindly suggest me
Thanks in Advance,
Niranjan
Can you check the value of the variable Vname in your qlikview application???
Just wanted to check have you written that variable or call that variable in script?
Regards,
Mayank
I think you forgot to use the variable before you pull from the database query
CONNECT TO $(Vname);
DIM1:
LOAD "FCT_TMPLT_ID",
"TMPLT_NM",
"TMPLT_STS_CD",
"TMPLT_EFF_DT",
"TMPLT_TERM_DT",
"TMPLT_CRE_USR_ID",
"TMPLT_CRE_TS",
"TMPLT_UPDT_USR_ID",
"TMPLT_UPDT_TS",
"BYPASS_IN",
"RAG_CMNT_CD",
"RAG_UPLD_IN";
SQL SELECT FCT_TMPLT_ID, TMPLT_NM, TMPLT_STS_CD, TMPLT_EFF_DT, TMPLT_TERM_DT, TMPLT_CRE_USR_ID, TMPLT_CRE_TS, TMPLT_UPDT_USR_ID, TMPLT_UPDT_TS, BYPASS_IN, RAG_CMNT_CD, RAG_UPLD_IN
FROM "OMP_MASTER"."MVW_TMPLT_FCTSETUP_CCB"
;
Thanks for your response its working
when its connecting to the database its asking user namd password,
connection string it self already has user name and passowrd.
Please suggest
If you don't create a variable, you don't see this behavior?