Discussion Board for collaboration on QlikView Scripting.
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
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