Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to indicate the password to access a DB in the script ?

Hello everyone,

To connect to a Oracle database, i have to enter a password in a pop-up.

The problem is each time I refresh the application, the pop up opens up and I have to manually enter the password... So I have to be in front of my computer if I want to refresh this app...

Is there a way to "write" the password in the script so I can plan the refresh ?

Here is the code I currently have to connect to my DB :

ODBC CONNECT TO [OPTDEC;DBQ=OPTDEC];

OPTDEC is the name of the database.

Thank you for your help.

Have a good day

Laura

1 Reply
Not applicable

Re: How to indicate the password to access a DB in the script ?

Hi Laura,

when you declare your database thru ODBC , --> configure , give password and login

When you do your connection in QV with the wizard, it normally writes

ODBC CONNECT TO [OPTDEC;DBQ=OPTDEC]  with login=blablabla, pasword=pwd

best regards

Chris

Community Browser