topic Re: DB2 Connection in QlikView

DB2 Connection

noman212 — Thu, 25 Sep 2014 05:14:27 GMT

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.

Re: DB2 Connection

er_mohit — Thu, 25 Sep 2014 05:38:12 GMT

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

Re: DB2 Connection

noman212 — Thu, 25 Sep 2014 05:52:16 GMT

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

Re: DB2 Connection

er_mohit — Thu, 25 Sep 2014 06:01:34 GMT

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);

Re: DB2 Connection

ashfaq_haseeb — Thu, 25 Sep 2014 06:03:56 GMT

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

Re: DB2 Connection

Thu, 25 Sep 2014 06:08:36 GMT

write like this

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

Re: DB2 Connection

Thu, 25 Sep 2014 06:12:57 GMT

write like this

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

Re: DB2 Connection

noman212 — Thu, 25 Sep 2014 07:16:26 GMT

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

Using 32-Bit OLEDB connection

IBM-DB2

Re: DB2 Connection

er_mohit — Thu, 25 Sep 2014 07:52:00 GMT

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

Re: DB2 Connection

noman212 — Thu, 25 Sep 2014 07:53:13 GMT

yes

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