DB2 Connection

[noman212]

DB2 is asking for user name and password each time for reload

how can i fix this?? at the time of making connection string i Checked Allow saving password.

[er_mohit]

Save the database connection string in txt file and call the txt file in qlikview using

$(Include=write pathname where txt file is saved);

Then Reload the fetching data it doesn't ask again for Username and password

Thanks & Regards

Mohit

[noman212]

Thanks for reply Mohit

Commenting Connection string and add this line

$(Include='C:\ProgramData\QlikTech\Documents\Connection');

In Connection.txt  File i defined connection string

its gives an error

ODBC connection failed

[er_mohit]

Try to again making new connection of ODBC then testing the connection if you get succed then cut the connection string from script and paste it in txt file and be sure when you calling the txt file in qlikview remove single quotes and write this way

On the top in main tab of script write this

$(Include=C:\ProgramData\QlikTech\Documents\Connection);

[ashfaq_haseeb · Accepted solution]

Hi,

Is it OLEDB or ODBC in any case make sure to click on save password.

Try by recreating new connection string.

hope it helps

regards

ASHFAQ

[#6]

hi

write like this

$(Include=C:\ProgramData\QlikTech\Documents\Connection.txt);

[#7]

hi

write like this

$(Include=C:\ProgramData\QlikTech\Documents\Connection.txt);

[noman212]

Its Ask for pasword i recreate connection string and stored connection string in text file.

Using 32-Bit OLEDB connection

IBM-DB2

[er_mohit]

Have you check on Force 32 bit  if not then do that also

[noman212]

yes

OLEDB CONNECT32 TO [Provider=IBMDADB2.DB2COPY1;Persist Security Info=True;User ID=abcuser;Data Source=cserver;Mode=ReadWrite] (XPassword is WTCTAYFMTbcQHcBPYDIB);