SAP BODS data store connection is not working in one local repo

[former_member595184]

Hi,

We are using BODS 4.2 and have multiple local repository which are using common data store connections. Suddenly data store connection for one of the bods SQL SERVER database in local one repo is not working. It is working for all other repos and apparently nobody knows this password for this specific data store connections. I am getting below message while viewing the data in the datastore in BODS :

ODBC call <SQLDriverConnect> for data source <XXXXXXX> failed: <[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'XXXXXXX'.>. Notify Customer Support.

Can you guys help how can I fix this ODBC error in that particular repo. Thanks.

[former_member466847]

Thank you for the update, it is possible to make a new test Database Datastore to this same account and see if the issue continues with a test job. it is possible the connection string is becoming invalid inside Designer.

Please know that 14.2.2.446 is no longer patch fixable nor has escalation support. So if you make a ticket you may be requested to recreated this error in a higher version of Data Services.

[former_member595184]

Hi Jessica- I updated the password in data store connection and the login error is gone and now I am seeing this new error :

ODBC call <SQLDriverConnect> for data source <XXXXXXX> failed: <[Microsoft][SQL Server Native Client 11.0]Invalid value specified for connection string attribute 'PWD'>. Notify Customer Support.

Do you have any thoughts how can I fix this? What is connection string attribute?