Skip to Content
0

Data store error on different repository

Jan 03 at 10:40 AM

52

avatar image
Former Member

Hi Experts,

I have promoted my new job and Data stores from Dev to UAT repository but the datastore config is failing with following error:

--------------------------- SAP Data Services Designer --------------------------- WARNING: Cannot establish database connection. 'ODBC call <SQLDriverConnect> to connect database <DS_Target> failed with error: <ODBC call <SQLDriverConnect> for data source <DS_Target> failed: <[MySQL][ODBC 5.3(w) Driver]Access denied for user 'user'@'XX.XX.XX.XXX' (using password: NO)>. Notify Customer Support.>. Use the ODBCDriverSelector (Windows) or DSConnectionManager.sh (UNIX) utility in LINK_DIR/bin to configure the correct version of the driver. If the problem still exists after selecting the correct version of the driver, notify Customer Support.' (BODI-1111341) Do you want to save the datastore anyway? --------------------------- Yes No ---------------------------

The same DSN is used in Dev repository and its working fine.

Please help.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Jan 03 at 10:48 AM
0

I have updated the password in the DS config and its resolved.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 03 at 10:48 AM
0

I have updated the password in the DS config and its resolved.

Share
10 |10000 characters needed characters left characters exceeded