Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

failed to update data source credentials:ADC:ERROR [Hype] [IBM][System I Access ADC Driver]

HI There,

 

We are successfully making a ODBC connection in the Power BI desktop with below connection string.

 

We installed a personnel gateway to schedule the report refresh on service. Unfortunately it was throwing errors.

 

Datasource Connection String : driver={iSeries Access ODBC Driver};system=MEDICAL.SC.COM;dbq=acomm;dftpkglib=QGPL;languageid=ENU;pkg=QGPL/DEFAULT(IBM),2,0,1,0,512;translate=1

 

Error Message: 

Failed to update data source credentials:ODBC:ERROR [HY000] [IBM][System I Access ODBC Driver]Key value in connection string too long.

 

Can you help me with this.