Skip to Content

Data store error on different repository

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 03 at 10:48 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 03 at 10:48 AM

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

    Add comment
    10|10000 characters needed characters exceeded