Variable error

[NavinReddy]

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

[saimahasan]

Can you check the value of the variable Vname in your qlikview application???

[mayankraoka]

Just wanted to check have you written that variable or call that variable in script?

Regards,

Mayank

[sunny_talwar]

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"

;

[NavinReddy]

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

[sunny_talwar]

If you don't create a variable, you don't see this behavior?