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]
