topic OLEDB Connetion failed error while loading the data in QlikView

OLEDB Connetion failed error while loading the data

Wed, 12 Nov 2014 12:19:41 GMT

Hi All,

Iam getting an error "OLEDB connection failed" when iam trying to reload the data into a QVD. My data source is AS400 / DB2 Please help.

Re: OLEDB Connetion failed error while loading the data

ashfaq_haseeb — Wed, 12 Nov 2014 12:25:06 GMT

Hi,

Did you established connection to DB from QlikView File?.

Which connecting string you use OLEDB or ODBC

Regards

ASHFAQ

Re: OLEDB Connetion failed error while loading the data

Wed, 12 Nov 2014 12:30:34 GMT

Hi Ashfaq,

below is my connection string and using OLEDB:

[Provider=IBMDASQL;Persist Security Info=True;User ID=tms;Data Source=SRC;Protection Level=None;Extended Properties='''';Initial Catalog=CTLG;Transport Product=Client Access;SSL=DEFAULT;Force Translate=65535;Default Collection= Schema;Convert Date Time To Char=TRUE;Catalog Library List='''';Cursor Sensitivity=3;Use SQL Packages=False;SQL Package Library Name='''';SQL Package Name='''';Add statements to SQL package=True;Unusable SQL Package Action=1;Block Fetch=True;Data Compression=True;Sort Sequence=0;Sort Table='''';Sort Language ID='''';Query Options File Library='''';Trace=0;Hex Parser Option=0;Maximum Decimal Precision=31;Maximum Decimal Scale=31;Minimum Divide Scale=0;Library List='''';Naming Convention=0;Query Optimize Goal=0;Query Storage Limit=-1;Handle Numeric Data Errors=1;Keep Trailing Blanks=False;Application Name=QvConnect64.EXE;Decfloat Rounding Mode=0;Decfloat Error Option=0;Client User ID='''';Client WorkStation Name='''';Client Program ID='''';Client Accounting='''';Block Size=0]

Re: OLEDB Connetion failed error while loading the data

ashfaq_haseeb — Wed, 12 Nov 2014 12:32:31 GMT

Hi,

Did this worked before.

Are you able to pull data from DB.

Make sure you specify db port too.

Regards

ASHFAQ

Re: OLEDB Connetion failed error while loading the data

Wed, 12 Nov 2014 12:36:58 GMT

Because when iam creating the connection string in the qlikview file its not showing any ports... if so how to specify the ports what tag to be used....

Re: Re: OLEDB Connetion failed error while loading the data

ashfaq_haseeb — Wed, 12 Nov 2014 12:48:15 GMT

Hi,

Have a look at attached image.

Regards

ASHFAQ

Re: OLEDB Connetion failed error while loading the data

Wed, 12 Nov 2014 13:22:11 GMT

Sorry ashfaq unable to fetch the port and IP numbers through Iseries

Re: OLEDB Connetion failed error while loading the data

ashfaq_haseeb — Wed, 12 Nov 2014 13:24:40 GMT

Check with your DBA he might help you.

Which oledb drivers you use?

Regards

ASHFAQ

Re: OLEDB Connetion failed error while loading the data

Wed, 12 Nov 2014 13:43:29 GMT

We use IBMDASQL OLEDB driver. we dont have a DBA here. We installed Iseries navigator and it is by default will give the drivers.