Connection failure.You must change the database setting - Access DB

[Anonymous]

Hi All,
I am getting below mentioned error message by using below mentioned steps
Error " Connection failure.You must change the database setting"
Steps:
1. Click on Metadata
2. Right click on DB connections, then create connections
3. Enter name as MyAccessDatabase and hit Next button at the bottom
4. Selected Access from DB Type drop down list
5. Leave blank for Login and Password fields
6. Click on Browse button to select a file (Ex: D:/MSAccess/MySampleDatabase.accdb)
7. By doing this String of Connection becomes "jdbc dbc river={Microsoft Access Driver (*.mdb)};DBQ=d:/msaccess/mysampledatabase.accdb"
8. Now when I hit Check button I got above mentioned error message.
Please let me know how should I proceed from here.
Thanks,
Jagmohan

[Anonymous]

Hello @Sanmathi

Which DB server are you trying to connect? MySQL 5 OR MySQL 8? On which talend build version you got this issue?

So far, Talend has added support for Mysql 8 in the db of studio as from the 7.1.1 version.

Best regards

Sabrina

[Anonymous]

Hello, @xdshi

i am using MySQL version 8

and i am using talend 7.0

Did talend 7.0 supports MySQL 8.?

[Anonymous]

Hello,

MySQL 8 is not list on the supported table for v 7.0.

For more information, please refer to this online documentation:TalendHelpCenter: Supported systems, databases and business applications by Talend components

Best regards

Sabrina

[Anonymous]

Thank you so much, as you said MySQL version is problem and i have cleared it now