Skip to Content
Jan 03, 2018 at 10:40 AM

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 (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.